M
medirate
I have a table of injury dates (field name injdate). I would like to produce
a crosstab query with the year on the left side (as rows) and the month at
the top (as columns). The total number of injuries appear at each
intersection of year and month. Is this possible? I created a query with
two fields, InjYear: Year([injdate]) and InjMonth: Month([injdate]). Any
pointers, including SQL code would be greatly appreciated.
If this is not possible, then instructions on how to do this in a report
will be helpful.
Thanks!
a crosstab query with the year on the left side (as rows) and the month at
the top (as columns). The total number of injuries appear at each
intersection of year and month. Is this possible? I created a query with
two fields, InjYear: Year([injdate]) and InjMonth: Month([injdate]). Any
pointers, including SQL code would be greatly appreciated.
If this is not possible, then instructions on how to do this in a report
will be helpful.
Thanks!