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.
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.