Grouping time in a query (97 SR-1)

Topic

New Reply

My database has a time field with an input mask of 00:00;0;_ . I wanted to know how to group together the time in a query. Like grouping together in two hour intervals and then counting how many in each time frame. Any help is greatly appreciated. Thanks.

Reply | Quote

Replies

That’s sort of a nasty thing to do – your best bet is to use calculated expressions to create modified time values that give you just the hour (try the Hour function), and then divide by two and do a Group By query.

Reply | Quote