Null Month records for a field

[c8tz]

Hi,

I have a query report made up of a number of queries. The query shows
monthly records for a year.
Problem is if one of the subqueries is null - contains no records for
this month then the month doesnt show in the query - even though in
the other subqueries there is data for that month.

I am thinking of using the Nz operation but would that be used in
relation to the month -

eg: Jan
Females : 40
Males : no record

Feb
Female: 20
Male: 50

In query: only Feb report would show.

How can i ensure that the month data report is shown even if there is
a null column record. and that would show as 0.

Thanks for assistance,

 

[Golfinray]

TRY:
Put a new field in your query and put this:
IIF([your field with dates or months] is null, "0",[your field])

 

[Duane Hookom]

It would help if you provided your SQL view of your queries. We can only
guess regarding your table structures and SQL.

Have you tried LEFT or RIGHT JOINs?