Results 1 to 2 of 2

Thread: median function

  1. #1
    Join Date
    Mar 2004
    Posts
    139

    Unanswered: median function

    I have a long term need for a median function, I was wondering if anyone has or knows of some code or user defined functions somewhere that would do this. Ideally you could use it just liket the rest of the aggregate functions like AVG, etc.
    Thanks,
    Bill

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi Bill

    You would need some sort of CLR code to use it like AVG etc.

    The SQL in the link below works (I translated it into Access SQL recently) however you will need to make minor modifications to account for nulls, not use the financial median etc.
    http://www.oreilly.com/catalog/trans...pter/ch08.html

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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