View Single Post
  #1 (permalink)  
Old March 19th, 2004, 01:11 AM
rangeview rangeview is offline
Registered User
Join Date: Mar 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Iif statement in Access

I am trying to teach myself Access and can't figure out an Iif statement. I have a field called Status, which uses either P, S, NS, R, or W. I want to calculate the sum of a field called BMUSbmTtl, but only if [Status] <> W. I've tried =Iif([Status]<>"W",sum[BMUSbmTtl])). I get a calculation, but it still calculates all records, including those where status =W.

What am I doing wrong?

Thanks for your help--ms