Multiple parameter values

  • Thread starter Thread starter Freida
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top