summary report

[Ryan]

hello,

I have a table that has 12 HSE stats + month+year fields. I have created a
query for the table, I would like to have a report that displays the data
similar to a summary statement as follows

grouped by year
grouped by location
performance stats january |february|march|april
hours 10 20 30 20
km 5000 5500 3200 2200
.....and for the rest of the 12 fields

not sure how to do this. any help would be appreciated

Ryan

 

[karl dewey]

Sounds like you need a crosstab query. Search on crosstab.
If you post the SQL of a select query that includes all the fields someone
could help.

 

[Duane Hookom]

There is a solution for creating a monthly crosstab query at
http://www.tek-tips.com/faqs.cfm?fid=5466.