Queries return nothing if some datas missing....Ah?

[paulmcdonnell]

Hi guys I have 3 separate queries which count the number of entries in a data set depending on set parameters. I have a summary query which simply collates the three queries counts and is the basis for a report.

Problem occurs when if one of the three individual queries returns no value the sum query returns no value also, even though the other two counting queries do have values.

I want the queries to return 0 if noting is there and show the correct info for the counts that are >0.. how can I do this?

Cheers
paul

 

[askey]

I'm trying to achieve similar results eg.

SELECT tbl_Assess_Level.Assess, Count(*)
FROM tbl_processed_data INNER JOIN tbl_Assess_Level ON tbl_processed_data.Assess = tbl_Assess_Level.Assess
GROUP BY tbl_Assess_Level.Assess;
where tbl_assess_level has values 1 - 4 and tbl_processed_data may or may not have values 1 - 4. I still get no records if count for a value is 0.

????????????????????????