A Access9001 Registered User. Local time Yesterday, 16:06 Joined Feb 18, 2010 Messages 268 Mar 28, 2012 #1 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?
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?
B Beetle Duly Registered Boozer Local time Yesterday, 17:06 Joined Apr 30, 2011 Messages 1,807 Mar 28, 2012 #2 =Sum(IIf([VariableName]>0,[VariableName],0))