When running query, how do I enter multiple data for a field

[Vtec]

I am new to MS Access.
I need to enter multiple data when running my MS query prompt.
When the Enter Parameter Value prompt appears, I can't enter more than 1
data value - using [Enter data] in the Design.
I can enter multiple data in the Criteria in the Design using Or but not
when I run it.
Do I need to create a form instead?
Pls help.
Thks

 

[Duane Hookom]

IHMO, never use parameter prompts. Always create forms with controls for
users to enter criteria values. For multi-select, use a list box. There are
lots of examples on the web of how to filter a query or report based on a
multi-select list box.

 

[Armen Stein]

IHMO, never use parameter prompts. Always create forms with controls for
users to enter criteria values. For multi-select, use a list box. There are
lots of examples on the web of how to filter a query or report based on a
multi-select list box.

Yes. If you're working on a report, then you can see an example of
using a form to specify report selection criteria on our web site:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
See "Report Selection Techniques".

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Vtec]

Dear Armen,

Thks a lot for your help

Yes. If you're working on a report, then you can see an example of
using a form to specify report selection criteria on our web site:
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
See "Report Selection Techniques".

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[Vtec]

Dear Duane,

Thks a lot for your help

IHMO, never use parameter prompts. Always create forms with controls for
users to enter criteria values. For multi-select, use a list box. There are
lots of examples on the web of how to filter a query or report based on a
multi-select list box.
--
Duane Hookom
Microsoft Access MVP

I am new to MS Access.
I need to enter multiple data when running my MS query prompt.
When the Enter Parameter Value prompt appears, I can't enter more than 1
data value - using [Enter data] in the Design.
I can enter multiple data in the Criteria in the Design using Or but not
when I run it.
Do I need to create a form instead?
Pls help.
Thks