Duplicates - Sorting

  • Thread starter Thread starter Paul Smith
  • Start date Start date
P

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
 
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
 
Back
Top