I'm trying to set up a report that looks like this
Jan Feb Mar Apr .....
Male 1 3 2 3
Female 8 0 4 1
TypeA 1 3 2 3
TypeB 9 1 0 11
TypeC 3 1 3 1
LocationA 3 2 0 1
LocationB 9 1 0 11
LocationC 5 1 3 5
Male/Female are strings in a gender column(field) that allows only "M" or "F". Similarly, Type and Location are string-type columns with selections only from a value list. Jan, Feb, etc are groupings by month, based on a date-type column(field).
I can make a crosstab queries for gender or Type or Location, but not all three. Is there any way that I can include all three queries as rows in the detail section of a report, so that it included all of the data?
Thanks,
Shin
Jan Feb Mar Apr .....
Male 1 3 2 3
Female 8 0 4 1
TypeA 1 3 2 3
TypeB 9 1 0 11
TypeC 3 1 3 1
LocationA 3 2 0 1
LocationB 9 1 0 11
LocationC 5 1 3 5
Male/Female are strings in a gender column(field) that allows only "M" or "F". Similarly, Type and Location are string-type columns with selections only from a value list. Jan, Feb, etc are groupings by month, based on a date-type column(field).
I can make a crosstab queries for gender or Type or Location, but not all three. Is there any way that I can include all three queries as rows in the detail section of a report, so that it included all of the data?
Thanks,
Shin
