I put ecaxtly what you said but as soon as I save the recordset it removes the CONCAT(). like this:
SELECT SUM(Air) AS numCount
GROUP BY Month, Day, Year, ampm
And its not totaling the numbers. heres the file.
inthe code you'll see I added the CONCAT() but still nothing and it still does not show up in the recordset.