Parameter query

C

Chi

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
 
D

Duane Hookom

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.
 
J

jahoobob via AccessMonster.com

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!
 
Top