Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Serbia and Montenegro (Yugoslavia)
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Averaging a Date (Access 2K2)

    I have a query where I wanted to get the average date/time by group of records. I took a shot at just putting the date field in the query grid and using the AVG aggregate. It returned a value in double format. I tried converting it to a date and it still didn't work.

    Is there a way to accomplish this?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Averaging a Date (Access 2K2)

    In the design view of the query, right click on the date field you want the average.
    Select Properties.
    On the general tab you have the property format.
    Enter there the format you want.
    Francois

Posting Permissions

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