Access Query Display where balance may be nil, positive or both
I have a query with the following column (the +1 is in order to make the calculation non-negative):
I want a criteria whereby the user can display either:
1. Where balances are all 0
2. Where balances are 1 or greater
3. All balances.
I came up with the following input message box, but inputting * for all balances gives no results at all:
Code:
[In stock only? 1=YES, 0=ZERO ONLY, *=ALL]
Any help given will be appreciated.
.
PC - Ubuntu 15.04 64bit Desktop
HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home
"So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"
RIP Ramesh ...