Multiple prompt criteria

[deeds]

I want to be able to enter 2 critieria from a prompt box when run query. Eg.
[Enter Product] AND [Enter Product]...can this be done? Thanks

 

[Allen Browne]

So you want to find *either* of the 2 values in the same field?

Try entering this in the Criteria row of query design:
[Enter Product 1] OR [Enter Product 2]

 

[Daryl S]

Deeds -

Yes, you can have multiple prompt criteria. You need to use different names
(e.g. [Enter Product] and [Enter second product]) if you want the user to
enter two different items.

 

[KARL DEWEY]

Do you have each product in a separate field like a spreadsheet?

--
Build a little, test a little.

Thanks...how do i then show all fields instead of having to choose 2. Is
there a way to show all? Thanks again!

Deeds -

Yes, you can have multiple prompt criteria. You need to use different names
(e.g. [Enter Product] and [Enter second product]) if you want the user to
enter two different items.

--
Daryl S

I want to be able to enter 2 critieria from a prompt box when run query. Eg.
[Enter Product] AND [Enter Product]...can this be done? Thanks

 

[Daryl S]

Deeds -

You can select any fields you want to show in query design.

Post your SQL statement and explain what you are getting and what you want
to get, and we can help more.

--
Daryl S

Thanks...how do i then show all fields instead of having to choose 2. Is
there a way to show all? Thanks again!

Deeds -

Yes, you can have multiple prompt criteria. You need to use different names
(e.g. [Enter Product] and [Enter second product]) if you want the user to
enter two different items.

--
Daryl S

I want to be able to enter 2 critieria from a prompt box when run query. Eg.
[Enter Product] AND [Enter Product]...can this be done? Thanks