Change valued in Access Table through VBA

[saketjn]

I have a table with several fields. One of them has 'names', which are duplicates for some rows. I want to change the duplicates to name_1, name_2 etc.

for ex: Baker, Steven might be repeated 3 times in the table. I want to update the fields with Baker_1, Steven Baker_2, Steven etc

[NeoPa]

You will have to do this using VBA.

As you haven't even started to look at a solution I'm afraid I can't be much help. You need to show us what you've tried and what does/doesn't work before we can assist (See How to ask a question).