Parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

As normal, I use parameter query to pull out single specific information.

Ex. If I enter Sue in Parameter dialog box, it will pull out Sue's
information.

If I want to pull out two names as once (Sue and Kim), what criteria I
should use?
Please show me how to do it.

Chi
 
The simplest and probably least flexible method is to use two parameter
prompts. Set the criteria under the column to something like:

Like "*" & [Enter First Name] & "*" or "*" & [Enter Second Name] & "*"

There are also methods that use the Instr() function or controls on forms
and code.
 
If you wan to get all of Sue's info and all of Kim's info you will need to
use two parameters [Name one] or [Name two] as your criteria. If you leave
parameter two blank, the query will use only parameter one. You can add as
many or [Name n] as you want.
Placing "Sue" and "Kim" in the criteria will not work!
 
Back
Top