how do i make sum if expressions?

[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

 

[Brendan Reynolds]

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

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.