Summing values in a report where value > 0?

Access9001

Registered User.
Local time
Today, 05:48
Joined
Feb 18, 2010
Messages
268
I have a report where I currently sum values by doing =sum([VariableName]) but I'd like it to only include values for which they are >0... is this doable?
 
=Sum(IIf([VariableName]>0,[VariableName],0))
 

Users who are viewing this thread

Back
Top Bottom