Null Month records for a field

  • Thread starter Thread starter c8tz
  • Start date Start date
C

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,
 
TRY:
Put a new field in your query and put this:
IIF([your field with dates or months] is null, "0",[your field])
 
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?
 
Back
Top