Jason,
This is working sort of. This is what I have:
SELECT SUM(Air) AS numCount
FROM tripmanifest
GROUP BY CONCAT (Month,Day,Year,ampm)
and it doesn't work. If I change it to:
SELECT SUM(Air) AS numCount
FROM tripmanifest
GROUP BY 'Month', 'Day', 'Year', 'ampm'
It totals ALL the numbers but not sorted by date. If I put the CONCAT() in ( like below)then it is deleted when I save the recordset.
SELECT SUM(Air) AS numCount
FROM tripmanifest
GROUP BY CONCAT('Month', 'Day', 'Year', 'ampm' )
...Something just hit me, How does the recordset know which Month, Day, Year, ampm to sort by? In the url to this page I am passing that info. Does that need to be included in the recordset?
Dean
