Link to home
Start Free TrialLog in
Avatar of exp vg
exp vg

asked on

Access - Crosstab Query - Group Days into Months

I have a crosstab I am creating, where the rows is location, and columns is months. However, the data count that fills the months columns is listed in individual days. Is there a way to create a cross tab query, and change days into their corresponding months to reduce the number of columns to just indicate months.

Additionally, I want to ensure that when grouped in months, the year is added to the month column header.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial