Finding Duplicates and updating information systematically

[Looking for Answers]

I have a table that uses the birthdate as the account number which, obviously
will have duplicates within the table. I would like to update the duplicate
birthdates systematically by adding a -1 or -2 etc. Is there a way to do
this using a query?

 

[Douglas J. Steele]

I don't believe it's possible using a query. I think you'll need code.

 

[John Spencer]

Also you would need to store Birthdate as a text value. You can't
append dash 1 or dash 2 to a date field.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================