Wildcard code for a query

N

nybaseball22

Hello. I have a query that pulls information based on 3 the contents
of three fields in a query. One example of the string I have in the
design view of the query is:

[Forms]![TrainAllqry]![Enrollment Date]

The problem I have is that these fields are not always populated. In
cases they are not ALL populated, the query returns nothing. Is there
a wildcard I can add to the end of this that will disregard the blank
field and only use the 2 other fields for the search if this field is
blank?

Thank you.
 

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

How to get query to return total using wildcard 1
Wildcard parameter query not working 5
Query results based on fields in a form. 2
Wildcard on an "INNER JOIN" 5
Query wildcard symbols 4
Null or NOT in another table 4
Calculated age field not populating after 1/1/09 1
Excel Wildcard in Excel array formula 0

Top