Via a group query, my output is this:
Month Animal Count Jan Dog 2 Jan Cat 3 Jan Mouse 6 Feb Dog 2 Feb Mouse 8
I want the output to look like this:
Animal Jan Feb Dog 2 2 Cat 3 Mouse 6 8
Novice
Windows 10 
Access 2016
Via a group query, my output is this:
Month Animal Count Jan Dog 2 Jan Cat 3 Jan Mouse 6 Feb Dog 2 Feb Mouse 8
I want the output to look like this:
Animal Jan Feb Dog 2 2 Cat 3 Mouse 6 8
Novice
Windows 10 Access 2016
I just ran a crosstab query on top of the previous query results and it did what I needed, so self-resolved!
Moderator
Windows 10 Access 2010 32bit
Not much info provided, but I think this video should give you some insight.
Good luck.
OOOps I didn't refresh the thread before posting. But the link is still a good reference.
Query Stacking Columns as Rows
Query with two columns to Rows
Posting Permissions
Reply With Quote