I am trying to group by date (month/year) but the data I am querying is in month/day/year/time. I changed the format of that cell to MM/yyyy and it displays the date in the desired result. But it does not group them, I assume because the grouping is being applied prior to the format change. So none of the dates are common becase of the time. So how do I do this? Can I do it in the query, I thought about LEFT but I still don't want the day which is in the middle of the 2 pieces of info I need so that won't work.