using an excel IF function in Access?

S

smithja6

I'm converting an old excel spreadsheet into Access (which
I'm new at).

I have query going but I am having difficulty finding
an "IF" function in the expression builder. Does it exist?

In excel my formula for one column was: if
(A10>0,"Positive","Negative"). It was simply outputting
if an expression was either negative or positive.

I would like to duplicate this operation using access. I
know I will no longer be using "A10" or cell numbers but
[bracketed field names].

Any ideas? thx in advance.
 
Top