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

  • Thread starter Thread starter Vtec
  • Start date Start date
V

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
 
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.
 
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.
Click to expand...

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
 
Dear Duane,

Thks a lot for your help

Duane Hookom said:
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


Vtec said:
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
Click to expand...
Click to expand...
 
Back
Top