Hello,
i use access 2007 and i have a table with customer details and their purchases. I need a query to calculate the average value of the last 5 purchases per customer, irrespective of the day those purchases took place. That is, one customer may have made his last 5 purchases between lets...