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

"szidi" <(E-Mail Removed)> wrote in message
news:FD07E170-234B-4E39-A7D8-(E-Mail Removed)...
> 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.

--
Brendan Reynolds