Hello Everyone,

I know there are multiple threads on the specifics of how to group for months on pivot tables. But, I haven't found an answer for my specific issue yet. Excel isn't allowing me to group by month on a pivot chart I have that is connected to an Access database. The specific columns that have dates are formatted in the Access file to be in MM/DD/YYYY. There are also no blanks in the database. I have seen posts on this topic in other forums, but have not found an answer. If anyone could help me out or guide me in the right direction, I'd greatly appreciate it.

Thanks in advance!