Results 1 to 2 of 2
  1. #1
    kizofilax is offline Novice
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    1

    How to get the average (or mid point) of date/time data types?

    Hello I am trying to do the following: I have these column with this data



    6:44:28 AM
    6:44:32 AM
    6:44:37 AM

    How can I get the average of these 3 dates? Ie: 6:44:32.33

    Thanks

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    An aggregate query is the epsilon E symbol when in query design view. I myself have never averaged time , but I would experiment with it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Managing Point in Time
    By Stressed in forum Database Design
    Replies: 1
    Last Post: 03-09-2010, 07:55 AM
  2. Managing Point in Time
    By Stressed in forum Programming
    Replies: 0
    Last Post: 03-01-2010, 08:47 AM
  3. Replies: 3
    Last Post: 12-03-2009, 04:38 PM
  4. How do I group & average at the same time?
    By B20Pete in forum Queries
    Replies: 1
    Last Post: 07-07-2009, 12:53 PM
  5. SQL Server/VBA Data Types - Long & BigInt
    By Patrick.Grant01 in forum Programming
    Replies: 0
    Last Post: 06-05-2009, 09:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums