Hi Everyone

I am quite new to Access and VBA, and wonder if you could please help me. I came across an article on calculating the median of a Recordset (http://www.fabalou.com/Access/Modules/recordset_median.asp). Is this an aggregate function that could be used on an Access report? I would like to be able to calculate the average growth of a column of amounts in the recordset of my report, for a project I'm working on (the function has been coded in VBA for Excel).

Please could you explain how I could use the MedianOfRst function on the Northwind database, for example? Could I use the function on each 'group' of an Access report's Recordset?

I'd really appreciate your help.
Cheers