Finding the Median when in a grouped Query

[jamesborne]

Dear Access Buddies,
I have a table called 'Orders' with the following fields:


-ID
-Date
-Customer

I have created a query that Groups each customer and counts how many times each customer has made an order (from the orders table). Then I found the Min(date) and Max(date) for each customer. Next I subtituted the Min date from the max date. Finally, I divided the result by the count that I found at the beginning.

All this hardwork gave me the average. The Query looks somthing like this:

Customer
Max Date
Min Date
(Max-Min)/Count [This is the average difference in time between the orders, for each customer)


Now, the question is, how can I find the median because its far more reliable than the mean in this case?

Thanks in advance,
J. Borne

[June7]

Google: Access query median

Here is one http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[jamesborne]

June 7, I tried googling that but all sources contained complicated code and considering my moderate level of programming, isn't feasible. But thanks anyway for contributing!

[June7]

I think VBA code is the only option. That MSDN article is probably the best you will get.

[orange]

Have you seen this one
http://support.microsoft.com/kb/210581