Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping time in a query (97 SR-1)

    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.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Grouping time in a query (97 SR-1)

    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.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •