Query display

[Bob]

I have a query that pulls information from different
tables into a query. However it only displays information
when all the fields in the query are filled in. How do I
get it to display all the information regardless of
weather there is information in a particular field or not.

 

[Bob]

When all the fields in the tables the query is pulling
from are filled that is.

 

[JohnFol]

So if one or more fields are missing the record should not be returned?

In every column you will need to enter the criteria

Is Not Null