I have a table with 3 fields;
ITEM_ID, TRANSACTION_DATE, TRANSACTION_TYPE
The table has about a half a million records and I want to filter it out to show me only the most recent date (1 record) for each TRANSACTION_TYPE (There is 4 different transaction types) for each ITEM_ID.
Is there a way to do this easily in an Access Query?
Thanks in advance!