I have a database which is for billings. It includes a table, tblpayments, with all payments. I have a report that will give beginning balances, payments added, invoiced amounts added and balance to date. That all works fine. My users want a column added which will return the date of the last payment made. How do I accomplish that? The payment date is included in tblpayments.
Thanks,
Shirley
Start Free Trial