in reply to Converting a Date/Time

Depending on whether the start of your buckets needs to be dynamic or fixed, you can move the whole logic into the database:

select -- this is database specific and I don't know the name of the Acce +ss function floor(convert_to_seconds(S_TIME)/600) * 600 as bucket, count(*) group by bucket

I don't have the Access manual, so I don't know what function you actually need to convert a date/time field to a number of seconds, but I expect a quick search in the help to turn up that link.