Median.mdb (intermediate)

Please consider donating $1 per sample downloaded, find out why here
Download
Median97.zip
Access 97 (28 KB)
Surprisingly, Access has no Median function, so you have to write one of your own. This sample database shows how to do that.

You use the function much like the built-in Domain functions (DLookUp, DMax, and so on). That is, you must provide the 1) field name, 2) table name, and 3) a 'Where' Criteria. When used in an aggregate query (see below) you MUST add each field 'grouped by' into the Where Criteria. See Help for more on Domain Aggregate functions.

 

Feedback

 

Need Winzip?

Return to Main Page