Displaying data from multiple fields in a query

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

Guest

I have a table that has (4) fields that contain explanations. What I would
like to do is create a query that will display the data if any of those
fields are filled in. I tried the "Is not null" in all of the criteria and
it displayed no records.

That only works if I do individual fields.

I am using Access XP 2003 Professional
 
How did you specify Is Not Null? Was this in the graphical query builder,
and you put Is Not Null on the same line under all 4 fields? That ANDs the
conditions together, so it would only return those rows where all 4 of the
fields were null. To OR the conditions together, put each one on a separate
row in the grid.
 
Thank you so much. It worked just like I wanted it to. I didn't know about
the "OR" function. Still learning.
 
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
Access Access Query Criterion 1
Searching Multiple Fields in a query 4
Using the "Forms Object" on more than field in a query table 2
Restrict Display in an Access 2007 Query 2
Access Access Report Works on One Machine but not Another 3
Query based on Check Box 1
Data Mismatch in Excel 2010 4

Back
Top