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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top