Query display

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

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
 

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

Creating a Chart on form from selected data in query. 0
M.S. Word 365 1
Split form 0
DLookup in Continuous form 0
Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2010 DB not fuctional with multiple users 2
How to have two tables on same line? 1

Top