Median Function

Results 1 to 2 of 2

Thread: Median Function

  1. #1
    Join Date
    Dec 1969

    Default Median Function

    I am trying to calculate the median in SQL. I am using SELECT MIN(fieldname), MAX(fieldname), MEDIAN(fieldname), AVG(fieldname)<BR><BR>SQL returns an error stating the Median function is not recognized. Is there a way to do this?

  2. #2
    Join Date
    Dec 1969

    Default What database?

    Median is valid, though not the way you&#039;re using... dunno if it&#039;s valid in Access though. Here&#039;s from BOL<BR><BR>Median<BR>Returns the median value of a numeric expression evaluated over a set.<BR><BR>Syntax<BR>Median(«Set»[, «Numeric Expression»])<BR>

Posting Permissions

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