Hi
I have a field containing a value either 1 or 2. I want to seach all the 1's or the 2's or shoe all records regardless.
When users run a query on the field, I want to use an option frame with 3 radio buttons (values set as 1,2+3) to allow the user change the criteria in the query to either "1", "2" or all. Im having trouble with the all
I've tried something like:
iif([option]=1,1,iif([option]=2,2,Like "*"))
Can anyone let me know where im going wrong
Thanks!
Nick
I have a field containing a value either 1 or 2. I want to seach all the 1's or the 2's or shoe all records regardless.
When users run a query on the field, I want to use an option frame with 3 radio buttons (values set as 1,2+3) to allow the user change the criteria in the query to either "1", "2" or all. Im having trouble with the all
I've tried something like:
iif([option]=1,1,iif([option]=2,2,Like "*"))
Can anyone let me know where im going wrong
Thanks!
Nick
Last edited: