Multi

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rob p - 07 Dec 2005 17:26 GMT

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

Reply to this Message

KARL DEWEY - 07 Dec 2005 23:57 GMT

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.

> Made a query that runs when I run a report. Query has one field call Field 1
> and one called Field 2.
[quoted text clipped - 11 lines]
> thanks.
> rob

Reply to this Message