Query display

  • Thread starter Thread starter Bob
  • Start date Start date
B

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.
 
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
 
Back
Top