Query blank when one sub query has no records

[Gkirkup]

I have a query with three sub queries, all returning a number from different tables. But when any one of the sub queries returns a blank, the entire main query is blank.
How do I stop this from happening? I have tried NZ() on the sub queries and on the main query, but the blank still happens.

Robert

 

[plog]

Sounds like you have an INNER JOIN which you need to change to a LEFT JOIN. Right click the line between the two datasources and choose the option that shows all from the appropriate table.