Help! Issues using option frame to use a wildcard in query, select true, false or all (1 Viewer)

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

To select a subset of records you add a WHERE clause . . .
. . . so to select all records, remove the WHERE clause, like . . .