Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2005
    Location
    Columbus, Ohio, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculate MEAN & MEDIAN (Access 2002 SP3)

    I am trying to build a query to calculate MEAN and MEDIAN for about 600 records.

    Is there a built in function for calculating MEAN and MEDIAN? I have my query right now to calculate Avg, Max, Min, and I need to add the other 2.

    Please Help.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Calculate MEAN & MEDIAN (Access 2002 SP3)

    Mean and Avg are usually taken to be the same thing. What do you want from a Mean that is different from Average?

    There is no built in median function. <post#=468774 >post 468774 </post#> has an attachement with an median function and some examples of how to use it.
    Regards
    John



Posting Permissions

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