Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Add decimals automatically to duplicates

Discussion in 'Information Technology' started by munkis29@yahoo.com, Jul 28, 2006.

  1. munkis29@yahoo.com

    munkis29@yahoo.com
    Expand Collapse
    Guest

    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?
     
  2. Loading...


Share This Page