Multiple parameter values

F

Freida

I want to know how to put a parameter into my query that will allow me to
input several values at one time. For example I have a query with New
enrollments, but they are enrolled in various plans:

Plan A
Plan B
Plan C
Plan D

I want to be able to choose A and D new enrollments in the same parameter.
Is this possible?
 
D

Duane Hookom

My reply would depend on whether the query was the record source for a form
or report. I think you want a multi-select list box on a form. This requires
some code to build a clause that can be used as a where condition.
 
F

Freida

the query would be the record source for the form-A multi select list box is
exactly what I want I just do not how to do it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top