Summing values in a report where value > 0?

Access9001

Registered User.
Local time
Yesterday, 16:06
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