Simple query question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am just now starting to learn queries and reports and have a
question which is probably so easy.

I have a query which uses several different tables with several fields
selected. When selecting the fields, some of them have information and others
don't. When running the query, some of the information is not showing up
because not all of the fields have data in them. How do I get those, in this
case "companies" to be included in the list of data even if not all the
fields have data.

Please help if you understand my question.
 
posting the SQL of your query would help.
so without seeing your code i can only guess.
you may have a criteria on one of the field that has a
null value and the null value doen't not fit the criteria.
if you do then add Or Is Null to the end of the criteria.
best guess i can make.
hope it helps.
 
Back
Top