summary report

  • Thread starter Thread starter Ryan
  • Start date Start date
R

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
 
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.
 
Back
Top