force fill (1 Viewer)

[Matthew Snook]

Suppose I have a table containing data identified by location and month; for instance:
City; Month; Number_of_Accidents.

How do I write a query that will return not only rows in which there are actually accidents reported, but a full 12 rows for every City whether any data occurs in a particular month or not.

So, if Portland has accidents reported only in January and September, I still want the query to come up with a row for each month...

City Month Accidents
Portland January 2
Portland February
Portland March
Portland April
Portland May
Portland June
Portland July
Portland August
Portland September 5
Portland October
Portland November
Portland December


Is there a way, other than cross-tab queries, to force such a return?

Thanks,

Matt

 

[llkhoutx]

I Union a table with all the columns and data values of Null.