Retrieving last three payments for each customer

[sjack]

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

[pbaldy]

Does this work for you?

ACC: How to Create a Top N Values per Group Query

[sjack]

Does this work for you?

ACC: How to Create a Top N Values per Group Query

Thanks! That answered my question. I'm a little surprised that SQL requires a couple of steps to get the right

[sjack]

Does this work for you?

ACC: How to Create a Top N Values per Group Query

Thanks! That answered my question. I'm a little surprised that SQL can't manage a query like this in one step.