I have a table (tblCustomerPayments) with the following fields:
Payment_Id
Payment_Customer_Id
Payment_Date
Payment_Amount
In Access 2003, I'm having trouble creating a query that returns the most recent three payments for each Customer_Id.
Any ideas?
sjack