Stupid Question - Using "LAST" in query

[htmlasp]

I have a table with 4 fields

PaymentID(autonumber PK) / PaymentPayer / PaymentDate / PaymentAmount

I want to do a LAST of query on PaymentDate to find the last payment date for each customer

When I set LAST under totals in the query on the Pay mentDate field it returns every row as if LAST is not even set

If I have John Smith paid on 4/2/14 and 4/15/14 I only want to show the 4/15 payment for John Smith.

[orange]

Don't use Last.
You need to find the latest PaymentDate for each PaymentPayer

SELECT
PaymentID
,PaymentPayer 
,PaymentDate 
,PaymentAmount
FROM YourTable
WHERE
PaymentD,ate = (SELECT Max(PaymentDate) from YourTable as X
                       WHERE X.PaymentPayer = PaymnetPayer)

Good luck with your project.