Create duplicate data

  • Thread starter Thread starter KerrynCJS
  • Start date Start date
K

KerrynCJS

I want to create duplicate data! Our subscribers records are held on access.
The primary key is an autonumber which acts as the membership number and for
most records is also the password for the majority of members to gain access
to files etc. However for a few members the password has to changed
regularly and therefore cannot be their membership number. I want to
duplicate the autonumber field into another field in the same table /
formwhich can be manually changed. These details are then exported as csv
files for the online register and also mail merged to emails. Has anyone
managed to do this?
 
Add a column to the table and use an Update query, something like:

UPDATE tblMyData SET [NewColumn] = [AutoNumberColumn] WHERE NewColumn Is
Null;
 
Back
Top