create a query showing records that are less than the max date
I have a table with three columns (ID, ProductIDNo, DateRecieved).
ProductIDNo field has duplicates with different DateREceived values.
I want to filter it to include all records that are less than the Max DateReceived for that record.
Is this possible? C--Users-Drelinger.D179434-Desktop-C.JPG