Hi there,
I try to delete duplicate serial number in the table
but keep the latest one and I could not get it to work. Could any one give me a hint? Thanks.
I have the following table named
tblSerialNo which has the following data
SerialNo Date
100 10/25/2002
100 12/28/2002
101 9/15/2004
200 7/24/2003
200 1/24/2004
After the deletion the table should contain the following data.
SerialNo Date
100 12/28/2002
101 9/15/2004
200 1/24/2004
I try to delete duplicate serial number in the table
but keep the latest one and I could not get it to work. Could any one give me a hint? Thanks.
I have the following table named
tblSerialNo which has the following data
SerialNo Date
100 10/25/2002
100 12/28/2002
101 9/15/2004
200 7/24/2003
200 1/24/2004
After the deletion the table should contain the following data.
SerialNo Date
100 12/28/2002
101 9/15/2004
200 1/24/2004