Re: Adding decimals to duplicate values

On 31 May 2006 07:39:35 -0700, munkis29@xxxxxxxxx wrote:

You're probably doing something very eh unorthodox. Why don't you
share with us the bigger picture so we can give better advise.
It's very unusual to have a table with a single field, to then have
duplicates in that field, and to then want to change the data type
from (long) integer to single/double.
There's got to be a better way.

-Tom.


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?

.