Adding decimals to duplicate values

Hey all,

Hopefully someone here can help me, I've got a problem and not sure how
to aproach it. I'm using Access 2003 and have a table with one field:
FileID in it there are many values, many of which are duplicates. I
need a way for a Access to automatically add decimals to duplicate
values. For example: I have values: 1200
1200
1200
1600
1600
and I need them to be auto-decimaled as: 1200.1
1200.2
1200.3
1600.1
1600.2
How can I do this, does it involve a query or macro I can make?

.

Relevant Pages