query too complex

[jlute]

UNEstNtWt: Nz([UNEstNtWtw],[UNEstNtWtv])

UNEstGrWt: IIf(Nz([SUBUNPKWtTotal],0)<>0,Round([SUBUNPKWtTotal]+
[UNEstNtWt],6),Round([SumOfSumOfUNPKWtlb]+[UNEstNtWt],6))

This returns the "Query too complex" error. I suspect it's because the
query is trying to run the UNEstNtWt Nz function at the same time as
it's trying to run the UNEstGrWt expression???

Any help is greatly appreciated - this one has been pounding me down
for a couple days now and no amount of Excedrin is helping!

Thanks!

 

[Jeff Boyce]

Sometimes separating the query into two (or more) that are "chained"
together has worked for me...

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JohnLute]

Hi, Jeff.

I actually had it set up like that but it still wouldn't behave!

--
www.Marzetti.com

Sometimes separating the query into two (or more) that are "chained"
together has worked for me...

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

UNEstNtWt: Nz([UNEstNtWtw],[UNEstNtWtv])

UNEstGrWt: IIf(Nz([SUBUNPKWtTotal],0)<>0,Round([SUBUNPKWtTotal]+
[UNEstNtWt],6),Round([SumOfSumOfUNPKWtlb]+[UNEstNtWt],6))

This returns the "Query too complex" error. I suspect it's because the
query is trying to run the UNEstNtWt Nz function at the same time as
it's trying to run the UNEstGrWt expression???

Any help is greatly appreciated - this one has been pounding me down
for a couple days now and no amount of Excedrin is helping!

Thanks!