Calculate Median

[tmercier]

I am attempting to calculate the Average & Median on a particular field in a query.

=Median("qry2007_KPI_AvgJan_A","ContractSignedToReceived")

query name is qry2007_KPI_AvgJan_A
field name is ContractSignedToReceived

I am getting #Name? error.

Any ideas why? Thanks for any help troubleshooting this.

 

[neileg]

I'm not aware that Access has a median function.