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.
 
When all the fields in the tables the query is pulling
from are filled that is.
 
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
 
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

REPORT / QUERY - sort order question 3
MS Access Query Design Question 0
Related tables and Queries 1
Problems with query relationships in linked foxpro database tables 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query based on form 7
Forms used to run query 6
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3

Back
Top