Manually calculating the median and mode for this 46,000+ row table will take too long by "manually" doing it.



Is there a query I can use to have Access find the median and mode for all rows that have a Report_Status='S' for my "Import_Sign_TAT" field and then display in ascending order of the document_type?

I am using Access 2003 if that makes a difference.