Query only returns Colum headings?

[Beyuduzz]

This is probably a simple fix, but not sure how.

I have a querey that searches 1 field from 4 seperate tables (don't ask, its
the only way to get it to work).

If one of the fields doesn't from the orginial table doesn't have any data,
it returns the colum headers only. how do I "trick" the query to return even
a null value or a zero.

This query is tied to a graph/chart. The graph is not being generated
because of this.

Thanks

 

[Allen Browne]

See:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

The article explains how to use outer joins, and take care with criteria in
the fields that are Null.