Query Criteria

If i have a question in a query such as [Which town?]

How can the use return the records for all towns?

Leaving the cell blank does not work, nor does using a *.

All help most welcome.
SweetingAAsked:
Who is Participating?
 
mbizupConnect With a Mentor Commented:
Set your criteria to

LIKE NZ([Which Town], "*")

Then if the user enters a blank, all records will show
0
 
SweetingAAuthor Commented:
Excellent
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.