In Access 97 I need a small SQL select query.
I have 2 tables CUSMAS and TRANSACTIONS.
There can be 0 or many dated transactions per customer.
I want to select each customer in a group (rout)'
and ONLY the one newest transaction for each customer.
If 0 transactions I still need the customer and transaction value = 0