access SQL query - group by date range (after midnight problem)
$5-10 USD
Completed
Posted about 13 years ago
$5-10 USD
Paid on delivery
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