access SQL query - group by date range (after midnight problem)

Hi,(MDB file attached this time) Attached is my MDB , need to populate a list of days with # of recordings for each day grouped by day. **Here is my problem:** all data that was recorded after midnight is going to the next day: i need it to go to the **previous** day . I tried this: **SELECT RecordedOnDate, COUNT(RecordedOnDate) AS RowCount, COUNT(SongID) AS [Total Amount] FROM InfoTable WHERE (RecordedOnDate > DateAdd('h', 5, #1/23/2011#)) AND (RecordedOnDate < DateAdd('h', 5, #1/24/2011#)) GROUP BY RecordedOnDate ORDER BY RecordedOnDate DESC** But cannot GROUP BY Thanks ELi