sharringtoncpa
asked on
Query to select last record
I have an access database that contains a table (table is Transactions_tbl) for all transactions for all customers. I need to run a query that will pull only the most recent transaction (field is Transact_Date) for every customer (field is Customer_ID) in the table.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks capricorn1. Your solution will save me a lot of time. Thanks again.
select *
from Transactions_tbl
where Transact_Date in (select max(Transact_Date) from Transactions_tbl as T where T.Customer_ID=Transactions