How to compare a sign
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53
How to compare a sign
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 -.
-
- 2StarLounger
- Posts: 117
- Joined: 22 Feb 2022, 09:04
Re: How to compare a sign
Never 0?
Use a nested IIF() perhaps?
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.
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.
-
- BronzeLounger
- Posts: 1412
- Joined: 08 Jul 2016, 18:53