Displaying data from multiple fields in a query

R

Rick

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
 
D

Douglas J Steele

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.
 
R

Rick

Thank you so much. It worked just like I wanted it to. I didn't know about
the "OR" function. Still learning.
 
Top