View Single Post
  #3 (permalink)  
Old March 21st, 2004, 05:36 PM
Steven Steven is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

So, to put it into your context:

=Iif([Status]<>"W",sum([BMUSbmTtl]),-1)

That will give you -1 for cases where status=W

I am a loud man with a very large hat. This means I am in charge