How do you find the median of a dataset in Microsoft access?

This is a tricky problem. There is no built in functionality to find the median in Access, but you can write some VBA code to do it for you: Microsoft.com/kb/210581">http://support.Microsoft.com/kb/210581

Excel is generally a quicker way to calculate the median unless the dataset is too large.