query too complex

  • Thread starter Thread starter jlute
  • Start date Start date
J

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!
 
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
 
Hi, Jeff.

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

--
www.Marzetti.com


Jeff Boyce said:
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!
Click to expand...
Click to expand...
 
Back
Top