Multiple searches in one query...

G

Goobz

Is there a way to use Like "*" & [Enter all, or part of the Location]
& "*" in the same query, on additional fields to narrow down a
result!?

I haven't tried it yet, and just don't wanna mess anything up! :)

I would like to use it on one query, and 2 different fields, to narrow
a search!?
 
L

Larry Daugherty

You've got it right. Entering nothing returns all records. Entering
something returns just those records that contain the string you
enter. This is a particularly powerful thing to do when you use a
form to launch your report. Have the criteria lines refer back to the
control(s) on the form.

HTH
 
J

John W. Vinson

Is there a way to use Like "*" & [Enter all, or part of the Location]
& "*" in the same query, on additional fields to narrow down a
result!?

I haven't tried it yet, and just don't wanna mess anything up! :)

I would like to use it on one query, and 2 different fields, to narrow
a search!?
Click to expand...

I believe you're limited to 64 fields in a single query. Two is NO problem.

John W. Vinson [MVP]
 
J

John W. Vinson

Elaborating, please...
Click to expand...

You can use

[Forms]![NameOfAForm]![NameOfAControl]

on the Criteria line of a query to have the query pull its criteria from
there.

John W. Vinson [MVP]
 
Top