median

[Christos]

Hi...

i am trying to display the median using a query.

Its pretty easy to find the average, max and min but i dont have any idea on how to find the median...

e.g in order to find the maximum i wrote:

query = "SELECT max(TotalMark) as max from MARK" _
& " WHERE Title = '" & title & "'" _
& " AND SubTitle = '" & subtitle & "'"

but for the median i dont know how to do it...

Can anyone please help me...

 

[Jon K]

Take a look at this thread about calculating median:-
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43576