View Single Post
  #6 (permalink)  
Old March 22nd, 2004, 04:57 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

To clarify even more:

that whole statement, if written into a module, would be:
Code:
If [Status]="W" Then
   intVariable = Sum([BMUSbmtbl)
Else
   intVariable = -1
End If
So it would return either the Sum, or -1

But Null should do you

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