Month, Year, Day and ampm are not MySQL reserved words, so there is no need to enclose them in single quotes.
writing the query without the quotes:
SELECT SUM(Air) AS numCount
FROM tripmanifest
GROUP BY CONCAT(Month, Day, Year, ampm)
should work just fine.
MySQL does not like the use of the standard single quote character " ' ", instead, you should use the backtick "`"
if you are going to use quotes in the SQL, you need to use the backtick instead of the single quote:
SELECT SUM(Air) AS numCount
FROM tripmanifest
GROUP BY CONCAT(`Month`, `Day`, `Year`, `ampm`)
