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