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!
 

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

Similar Threads


Back
Top