criteria help

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

Guest

In a query under four fields I have the criteria

Like "*" & [Type ...] &"*"

However, when nothing is typed in the criteria, it does not full all the
records. How do I make it so that when left blank, the criteria is blank or
Like "*".
 
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

Access Dcount (multiple criteria) 3
Use In() Expression as Query criteria with guts from Function 1
query relelated to 2 combo boxes 2
Criteria in a Querie 8
Parameter Query multiple criteria help 6
Using "Count" in Queries 1
Criteria Question 2
How do I include the blank fields in a Query? 2

Back
Top