Multiple searches in one query...

  • Thread starter Thread starter Goobz
  • Start date Start date
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!?
 
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
 
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]
 
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]
 
You must log in or register to reply here.

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

Date search query 0
query criterion management 2
Record contains wildcard char 2
Searching Multiple Fields in a query 4
Run 2nd query using results from 1st query 0
Look up combos in Query Criteria? 3
Query based on Check Box 1
Access Dcount (multiple criteria) 3

Back
Top