Empty cells Query to not work.

[FreddieLeaf]

I have a Query pulling data from several tables. If there are empty cell with no data in them, they cause the Query to completely skip that record. It does not show up in the Query. Not practical since most of the data int the table will not be entered until some time later.

What gives? Is there a way around this?

Thanks.

 

[Rich]

Your joins are the wrong way around in the query, change them