I've got a list of date thus:

date salesperson amount of sale

and a second table that I want to create thus:

salesperson number of sales average sale median sale



I can get the count by uning dcounta, but can't make the daverage function
work in this context. Is there a trick to this? And I have no idea how to
get the median. Any help appreciated.
--
Jay