Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Sep 2001
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Median Function in Totals Query (ac2000)

    The current database I am working on requires a Median output.

    If possible, I would like to build it in a Totals Query.

    I search the WOPR. I tried to access the support.microsoft.com but it timed out on both these articles. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>
    Q209244 Reporting the Median Value of a Group of Records
    Q210581 Coding median

    Help please

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Median Function in Totals Query (ac2000)

    Hi Sandy,
    I've pasted the text of both of those KB articles into a text file, which is attached. I don't think either of them is exactly what you're looking for, but will hopefully give you some ideas!
    Hope that helps.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Median Function in Totals Query (ac2000)

    Actually, the attachments Rory sent you look pretty close to what I think you are after. The Control example where they use a series of controls looks like a litle magic to me, but the code seems pretty straightforward. Good luck.
    Wendell

  4. #4
    Lounger
    Join Date
    Sep 2001
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Median Function in Totals Query (ac2000)

    Thanks to you both. Those are the articles I was trying to retrieve earlier today. My line was timing out.

    I will work with the code and get back to you with the results!

Posting Permissions

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