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!
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!