I want to get the most recent item per client from a table.
ItemID (primary key, autonumber)
Date (date)
ClientID (foreign key, integer)
If I select ClientID (group by), Date (Max), then I get the results I'm expecting, but I want to also return the ItemID so that I can join some other...