hockeyfan21
Registered User.
- Local time
- Today, 15:05
- Joined
- Aug 31, 2011
- Messages
- 38
Hi,
I am trying to Sum two fields in my query with an IIf statement that only applies to one of the fields. I keep getting syntax errors and can't figure it out.
Calc Rjct Qty: Sum(([OM Rjct Qty],IIf([Rjct Sched Rsn Cd] In ('Z4','Z5','Z6','Z7','Z8'))+[Uncnfm Qty],0))
Want to Sum OM Rjct Qty IIf it = the Rjct Sched Rsn Cd then add that total to Uncnfm Qty.
Thanks for any help with this!
Toni
I am trying to Sum two fields in my query with an IIf statement that only applies to one of the fields. I keep getting syntax errors and can't figure it out.
Calc Rjct Qty: Sum(([OM Rjct Qty],IIf([Rjct Sched Rsn Cd] In ('Z4','Z5','Z6','Z7','Z8'))+[Uncnfm Qty],0))
Want to Sum OM Rjct Qty IIf it = the Rjct Sched Rsn Cd then add that total to Uncnfm Qty.
Thanks for any help with this!
Toni
