Multi

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

Made a query that runs when I run a report. Query has one field call Field 1
and one called Field 2.

Field 1 could be 8, 9, or 10.

Field 2 could be 1, 2, or 4.

I want a prompt for each field where enter would include all or else I could
type in the numbers I want to be included. Key is I may want 1 number in
field or more than 1 number.

Like [x] seems to give me only one.

thanks.
rob
 
Try a form with a multi-select listboxes. Include an asterisk as default.
In the design view of the query for criteria put each listbox on a different
row.
The criteria would be like --
Like [Forms]![YourFormName]![ListBox]
If you do not select anything then the asterisk will be a wildcard to pull
everything.
 
Back
Top