Duplicates - Sorting

[Paul Smith]

I have some dated date as below:

1/1/2005 125487 ...
2/1/2005 125487 ...
3/1/2005 12846F ...
1/1/2005 1248G ...
4/1/2005 125984 ...
4/1/2005 125984 ...
4/1/2005 125984 ...

I would like to remove all the duplicates, leaving just one instance and
that instances being the latest.

Any help anyone?

PWS

 

[[MVP] S.Clark]

The following will create a new table with the MaxDate per whatever the
other field is called.

Select Max([TheDate]), [TheOtherField] INTO NewTable FROM TableName GROUP BY
[TheOtherField]

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting