"Query is too complex"..??

  • Thread starter Thread starter HollyS
  • Start date Start date
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
 
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)))
 
Back
Top