Query Problem

[rexie]

I have a query which is pretty cumbersome. I have 10 fields, Below give is juts an example

FLD1 = (A*B)+C
FLD2 = IF FLD 1 > 100 then 0 is added to FLD2
FLD3 = IF FLD 2 > 100 then 0 is added to FLD3and so on
FLD4
FLD5
FLD6
FLD7
FLD8
FLD9
FLD10

But the problem is after populating FLD5, it is giving me and error "QUERY is too Complex"

SO what I did is, is to divide the query into 2, i.e Run Query 1(with 5 flds Populated) and then run Query2(populate the next 5).

Now, when I try to use a FLD from Query1, it is trating it as a Parameter, ie., when I try to run Query2, it pops out with a input box to enter some value,

Can someone please help me from this misery.


PLEASSEEEEEEEEEEEEEEEEEEEEEE

 

[blom0344]

Hello Rexie,

Your query looks absolutely pointless to me , just adding 0 to a field when a condition is true, but I think I just don't see what your doing from your example.
Did you try first creating a 'make-table' query on the first 5 fields and basing your second query with next 5 fields on this temporary table?

 

[rexie]

Hi Blom0344,

the example was just for explaination(not the best obe), yes u are right, I am moving in values(None zero computed values). What I figure is there are many IIF conditions, any suggestions