"Query is too complex"..??

H

HollyS

I have a very large w/ many joins& many calculations Make Table query that I
frequently use and I need to make one little chg to.

Most of the fields I am drawing from come from one large table but I have 5-6
other tables joined in - many of the fields being calculated are interdependent
(I need one completed to do the next calc)

So I made the chg:

-from-
POTENTIAL_CASH_OUT_HIGH:
IIf([POTENTIAL_CASH_OUT_HIGH_VAR]>300000,300000,[POTENTIAL_CASH_OUT_HIGH_VAR])

-to-
POTENTIAL_CASH_OUT_HIGH:
IIf([POTENTIAL_CASH_OUT_HIGH_VAR]>300000,300000,IIf([POTENTIAL_CASH_OUT_HI
GH_VAR]<0,0,[POTENTIAL_CASH_OUT_HIGH_VAR]))

and I get the message' Query is too complex' when I try to run it - I have
tried removing most of the small tables and every other field and calc that is
not interdependent to the core group of calculations this query creates...but I
always get the same message! Its such a small addition and I thought for sure
by removing several of the fairly large calculated fields it would let me do it
but it won't. Does anyone have any suggestions for me? Thanks in
advance....Holly
 
K

Ken Snell

Is POTENTIAL_CASH_OUT_HIGH_VAR ever a Null value? That may also be causing
the error message.

Assuming that it might be:

POTENTIAL_CASH_OUT_HIGH:
IIf(Nz([POTENTIAL_CASH_OUT_HIGH_VAR],0)>300000,300000,IIf(Nz([POTENTIAL_CASH
_OUT_HI
GH_VAR],0)<0,0,Nz([POTENTIAL_CASH_OUT_HIGH_VAR],0)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top