using wildcards for user input

[koncreat]

I have a field, shift, that is in the query and is a number field. When the query runs the it prompts the user to enter 1, 2 or 3. What i need to know is it possible for a user to enter a wildcard that will select 1, 2 and 3 and return all records? I have tried * but it doesn't work.

[pbaldy]

You can see if this works with the bracketed parameter, and leave it blank for all:

http://access.mvps.org/access/queries/qry0001.htm

Most of us use forms to get user input; you have much more control.

[Bulzie]

As pbaldy said, better to use field (combobox) on form. But maybe can try this in the criteria for Shift in the query

Between [First] And [Last]

To get shift 1 they enter 1 for both values. To get all shifts they enter 1 for First and 3 for Last.

[CJ_London]

* only works with like, not =.

You can use like on number fields so your user would enter

1,2,3 or * for all records

and your criteria for [Shift] would be

like [Enter 1,2,3 or * for all]

[Micron]

If the user can select one or all three, will it never be desirable to select two of the three? There seems to be seven possibilities, yet only four are being offered.