Query Criteria Results

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

Guest

I have a query with many fields but I want the output to show only those
records that have data in one of the fields. If this particular field is
blank, I do not want the query to show that record.

Thank you.
 
In the criteria for that field put the following. It takes care of Nulls,
zero length strings, and spaces all which can be construed as blank.

Is Null Or "" Or Like " *"
 

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
Access Access Query Criterion 1
#error - Blank 3
eliminating criteria in a query 4
counting Null fields 3
running total of records in query 1
Blank Fields in NOT Null Query Criteria 5
Make table query: [Enter 1] AS Test 1

Back
Top