Showing all months

[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

 

[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?

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.

 

[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