HOW TO DELETE DUPLICATE DATE FROM TABLE 1

[pelagic]

Hi there,

My table (tblWareHouse) has the following data:
SerialNo EnterDate
100 12/25/03
100 12/25/03
100 12/25/03
200 08/14/04
200 08/14/04
Is there a way to delete all the duplicate serial number and date but save one record from each group?
The result in this case is
SerialNo EnterDate
100 12/25/04
200 08/14/04
I tried to do in Access Query and Access Code but I couldn't get it to work.

 

[PHV]

Make a new table with select distinct .. into ..

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244