Search results

I am trying to set up a query to select PaymentDate, CustSurname, CustForename, AgentName showing only the last record for each customer if the last payment is over 7 days and also include customers with no payment. the table structure is: tblLoans LoanID (PK) CustID (FK) AgentID(FK)...