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