Change Field in SQL problem

[Bob V]

I have replaced QryOverdue.Payable with tblAccountStatus.PaidAmount, buy now
my query has gone from the correct 25 records to 256 records
Please any help..........Bob
**OLD**
SELECT QryOverdue.Name, Max(tblAccountStatus.BillDate) AS LastDate,
QryOverdue.Payable, tblOwnerInfwnerFirstName, tblOwnerInfwnerLastName,
tblAccountStatus.OwnerID
FROM (((tblAccountStatus INNER JOIN tblOwnerInfo ON tblAccountStatus.OwnerID
= tblOwnerInfwnerID) INNER JOIN QryOverdue ON tblOwnerInfwnerID =
QryOverdue.OwnerID) INNER JOIN qPaidAmountForPayment ON QryOverdue.OwnerID =
qPaidAmountForPayment.OwnerID) INNER JOIN qTotalDueForPayment ON
qPaidAmountForPayment.OwnerID = qTotalDueForPayment.OwnerID
GROUP BY QryOverdue.Name, QryOverdue.Payable, tblOwnerInfwnerFirstName,
tblOwnerInfwnerLastName, tblAccountStatus.OwnerID
ORDER BY QryOverdue.Name;

**NEW**
SELECT QryOverdue.Name, Max(tblAccountStatus.BillDate) AS LastDate,
tblAccountStatus.PaidAmount, tblOwnerInfwnerFirstName,
tblOwnerInfwnerLastName, tblAccountStatus.OwnerID
FROM (tblAccountStatus INNER JOIN tblOwnerInfo ON tblAccountStatus.OwnerID =
tblOwnerInfwnerID) INNER JOIN QryOverdue ON tblOwnerInfwnerID =
QryOverdue.OwnerID
GROUP BY QryOverdue.Name, tblAccountStatus.PaidAmount,
tblOwnerInfwnerFirstName, tblOwnerInfwnerLastName,
tblAccountStatus.OwnerID
ORDER BY QryOverdue.Name;

 

[Bob V]

Got It ...............Bob
SELECT QryOverdue.Name, Max(tblAccountStatus.BillDate) AS LastDate,
Last(tblAccountStatus.PaidAmount) AS LastOfPaidAmount,
tblOwnerInfwnerFirstName, tblOwnerInfwnerLastName,
tblAccountStatus.OwnerID
FROM (tblAccountStatus INNER JOIN tblOwnerInfo ON tblAccountStatus.OwnerID =
tblOwnerInfwnerID) INNER JOIN QryOverdue ON tblOwnerInfwnerID =
QryOverdue.OwnerID
GROUP BY QryOverdue.Name, tblOwnerInfwnerFirstName,
tblOwnerInfwnerLastName, tblAccountStatus.OwnerID
ORDER BY QryOverdue.Name;