Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: Is there a group by function to get the middle number?

    I am trying to right a MS Access query in MS Access 2003 to get the median (middle value) of a list of records. Is there such a function in MS Access or MS Excel?

    Thanks
    Mo

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Google

    builderau has something that should work
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    Hi,
    Not sure what you mean.
    Mo

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    well follow the google link
    examine the pages it references
    form my perspective the reference from builderau looked as if it did what you wanted
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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