is there an equivalent to sumif in Access. I very much appreciate any help. I am using Office 2000
H Huson Feb 12, 2009 #1 is there an equivalent to sumif in Access. I very much appreciate any help. I am using Office 2000
F fredg Feb 12, 2009 #2 is there an equivalent to sumif in Access. I very much appreciate any help. I am using Office 2000 Click to expand... No SumIf but you could use Sum() with criteria. =Sum(IIf([SomeField] = "XYZ Co.",[Amount],0))
is there an equivalent to sumif in Access. I very much appreciate any help. I am using Office 2000 Click to expand... No SumIf but you could use Sum() with criteria. =Sum(IIf([SomeField] = "XYZ Co.",[Amount],0))
