Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Averaging - How Do I ....

    I'm trying to determine the average delivery time of X, over the course of days, or weeks. I use a parameter query to identify the value for X, and another one for the start day of the period I'm looking at (will always be from date whatever to current date). What I don't know how to do is to have the query spit back out the average of all the days sampled. It instead reports back every day. I've also tried to build a report to show this with Groupings also without success. I don't need the output to be flashy, I'm just more interested in the value, so down and dirty is better. Help is greatly appreciated.
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    If you change your two criteria columns from "Group By" to "Where" then the query will return the average over the entire set of data. Post back with more details if that isn't exactly what you are after.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Jun 2010
    Location
    Quincy, MA
    Posts
    62
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Works perfectly, thank you very much for your help.

Posting Permissions

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