Showing all months

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
 
J

John Vinson

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.
 
M

Mike Dinnis

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
 
Top