Query to increment a duplicate value?

[munkis29]

Hello All,

I'm hoping someone here can help me, I'm an SQL newbie and need to do
the following:
I have a table and inside it contains one field, FieldID, in that field
there are many values, many of which are duplicates, this is fine,
however I want to have them numbered with a decimal. For instance a
portion of the field has the following values:
1200
1200
1200
1600
1600
I want to be able to run a query that will change those to:
1200.1
1200.2
1200.3
1600.1
1600.2
and so on. How can I do this?

 

[John Spencer]

Does the table consist of only the one field? If so, the only way I know to
do this would be to use VBA and an ordered recordset. I can think of no way
to do this in an SQL statement.

If you do have other fields, do you have one (or more) that can be used to
uniquely identify the ID row (in other words, do you have a primary key).