I have a table with three columns (ID, ProductIDNo, DateReceived).
ProductIDNo field has duplicates with different DateReceived values.
I want to filter it to include all records only for Max DateReceived for that record.
Is this possible?
I posted a similar, but opposite, question yesterday (thank you for the help, Rey)
Below selects all of the records that are less than the Max DateReceived :
FROM CPEQUP T
(SELECT CPEQUP.ProductIDNo, Max(CPEQUP.DateReceived) AS MaxOfDateReceived
GROUP BY CPEQUP.ProductIDNo) As T1
Where T1.MaxOfDateReceived Is Null