How to compare a sign

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

How to compare a sign

Post by bknight »

Suppose I have a record that contains a +1, how do I put an if statement that looks for n<0, conversely if the record contained a -1 the if statement would search for n>0. Both instances need to be evaluated in the if statement because the original value is either a + or -.

User avatar
Gasman
2StarLounger
Posts: 104
Joined: 22 Feb 2022, 09:04

Re: How to compare a sign

Post by Gasman »

Never 0?
Use a nested IIF() perhaps?
Using Access 2007/2019.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.

bknight
BronzeLounger
Posts: 1389
Joined: 08 Jul 2016, 18:53

Re: How to compare a sign

Post by bknight »

Gasman wrote:
29 Apr 2023, 20:27
Never 0?
Use a nested IIF() perhaps?
Never a zero, that is correct.
I'm not sure how to structure a nested f for all/both conditions.