A Access9001 Registered User. Local time Today, 05:48 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 Today, 06:48 Joined Apr 30, 2011 Messages 1,807 Mar 28, 2012 #2 =Sum(IIf([VariableName]>0,[VariableName],0))