Does not Display Query Result

[math20]

Hi,

I have 4 queries each query sums up one specific criteria. I have another query that looks at each one of these query and captures the sum value and shows in one record with 4 fields. When one of these query does not have any value my final query does not return any result even if I have results for other 3 queries.

Can anyone please help me with this.

 

[dhookom]

Can you provide any tables and fields and SQL views? Are the queries joined in your final query? Do you understand what LEFT and RIGHT JOINS are?

Duane
Hook'D on Access
MS Access MVP