How can I make this query
I have the following data
year race date starts track
2004 8/14/2004 1 freehold
i am trying to change this data base into this report format.
year type jan ..... dec total
2004 starts 1 ..... 5 6
2004 points 5 ...... 10 15
Would have months jan - dec in title. For starts you just count the number of times raced at the different tracks.
For points you only count each track/day once
I am using access 2007 to do this and I am not sure what the best way to proceed is.
Any help would be appreciated.