Put the "Date" that's the parameter of your MonthName function in double quotes so that SQL doesn't see it as a reserved word.
Sorry, I just wrote it down wrong
FROM \"Invoices\" a
WHERE YEAR(a. \"Date\") = YEAR(CURDATE)
ORDER BY a.\"Date\" ASC
My problem is when I use this It dose not group together MONTHNAME it gives me 30 days that say "SEPTEMBER" or what ever month in that date for the day. and when I add GROUP BY MONTHNAME(a.\"Date\") I get an error. See attached