how do i make sum if expressions?

S

szidi

until now i worked in M Excel, but now i'd like to change to Access
I have the following formulas that i'd like use in Access but don't know how

SUM IF (f2:f2000;Paper;i2:i2000)
and where should i introduce this expression

Thanks
 
B

Brendan Reynolds

szidi said:
until now i worked in M Excel, but now i'd like to change to Access
I have the following formulas that i'd like use in Access but don't know
how

SUM IF (f2:f2000;Paper;i2:i2000)
and where should i introduce this expression

Thanks
Click to expand...


Check out the "IIF" function in the help files. It can be used in queries,
in the control source of a text box on a form or report, or in VBA code.
 
Top