The following query works well except when i try to add GROUP BY
SELECT *
FROM tblEvents AS EVT
WHERE EVT.Online='1' AND (etc)
ORDER BY EVT.Date ASC, EVT.Time
GROUP BY State
How to re format so i can aggregate for States together (groupings ordered alphabetically by State), then within each State, ordered by date
thank you!