View Single Post
  #4  
Old October 24th, 2008, 01:02 PM posted to microsoft.public.access.queries
[email protected]
external usenet poster
 
Posts: 90
Default ack!!! simplify to resolve Query too complex ack!!!

OK. I corrected the statement to Doug's suggestion:
UNEstNtWt: Switch([tblFGUOM].[UOMType]="WT",Round([UNNtWt]*0.05+
[UNNtWt],6),[tblFGUOM]*.[UOMType]="VOL",Round([UNNtWt],6))

This is behaving. Obviously, my "or" setup was faulty.

Now I'm back to square one! Query too complex / System resource
exceeded. Simplify to this and all is good:
UNEstNtWt: Round([UNNtWt]*0.05+[UNNtWt],6)

Sorry for all of this craziness. I'm trying to work it out but not
doing so well. I'll leave it here and wait for any replies.