As you are working with databases the simplest and neatest way to do this is
with SQL, something along these lines:

select
id,
added_date,
term_text
from table1 t1
where
added_date =
(select max(added_date)
from table1 t2
where
t1.id = t2.id
group by id)
order by
id asc


RBS


"DPCpresto via OfficeKB.com" <u44264@uwe wrote in message
news:993bb85d2fe66@uwe...
I have a table of data that contains a column with a unique property code
ID,
(say Column X) and a column that contains a date on which periodic
maintenance (with a unique name) was completed (say Column Z). This data
is
pulled from the server into Access and exported to Excel, based on
whatever
date parameters I specify. Most of the time, I will get some duplication
of
properties that may have several dates for the same type of maintenance.
What
I want to do in Excel is parse out (or delete from the list) all the
duplicate properties, leaving only the one with the latest date, and, of
course, leaving all the other properties that have only one date listed.
Is
that possible with VBA?

--
DPCpresto

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200907/1