Remove duplicates based on date in another column

[mlhend2002]

Hello,

I am new to Access 2007 and am looking for macro/script to go through one column, looking for duplicate values and when found change the status of the record from active to inactive in another column, based on the date found in another column on the same spreadsheet. I have an access database with over 7000 entries that would take me days to go through manually.



Thanks in advance,

Mark

[RuralGuy]

Can you create a query that returns just the records you are interested in?

[mlhend2002]

There are probably 3000 duplicates. Basically, I need a query to find duplicates in one column, and make the one that is older (based on the date in another column) inactive.

[RuralGuy]

By "column" I assume you mean "field". If the duplicate is another record then it is an entirely different problem.

[mlhend2002]

Sorry, I'm use to working with Excel documents..Yes, field

[RuralGuy]

If the fields are on the same row (record) then you should be able to create query that selects only the records you want. Can you?