how do i make sum if expressions?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

szidi - 10 Jan 2008 16:09 GMT

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

Reply to this Message

Brendan Reynolds - 10 Jan 2008 16:55 GMT

> 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
[quoted text clipped - 4 lines]
>
> 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.

Signature

Brendan Reynolds

Reply to this Message