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.
Additionally, I want to ensure that when grouped in months, the year is added to the month column header.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.