Showing all months

  • Thread starter Thread starter Mike Dinnis
  • Start date Start date
M

Mike Dinnis

Hello,

I'm trying to create a query that returns all months of a year (Jan - Dec),
but not all months will have data to report upon. How can I fool the query
into showing all months regardless of the data?

Cheers,

<M>ike
 
Hello,

I'm trying to create a query that returns all months of a year (Jan - Dec),
but not all months will have data to report upon. How can I fool the query
into showing all months regardless of the data?
Click to expand...

If it's a Crosstab query, set the Headers property to
"Jan";"Feb";"Mar";<etc>

If it's not, create a little twelve-row table with the month names in
it and Outer Join it to your query.
 
Thanks,

I've created a new table as suggested and linked it. I find it best to left
join so that all records from teh month table are shown and only those from
the other table that match are shown. It foorces all months to appear.

<M>ike
 
Back
Top