If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
Current
TABLE 1
Col1 Col2 Col3 Col4 Col5 Col6
657 BB 0 10/08/2011 09:05 User
658 BB 1 10/08/2011 09:05 User
659 BB 2 10/08/2011 09:06 User
660 BB 3 10/08/2011 09:06 User
661 BB 8 10/08/2011 09:06 User
662 BB 9 10/08/2011 09:06 User
663 BB 10 10/08/2011 09:06 User
664 BB 11 10/08/2011 09:06 User
I want to copy the above rows into the same table with replaced col2 values as CC. Also note that Col1 is autonumber so i would like the new set of rows autonumbered.
DESIRED RESULT
TABLE
Col1 Col2 Col3 Col4 Col5 Col6
657 BB 0 10/08/2011 09:05 User
658 BB 1 10/08/2011 09:05 User
659 BB 2 10/08/2011 09:06 User
660 BB 3 10/08/2011 09:06 User
661 BB 8 10/08/2011 09:06 User
662 BB 9 10/08/2011 09:06 User
663 BB 10 10/08/2011 09:06 User
664 BB 11 10/08/2011 09:06 User
num CC 0 10/08/2011 09:05 User
num CC 1 10/08/2011 09:05 User
num CC 2 10/08/2011 09:06 User
num CC 3 10/08/2011 09:06 User
num CC 8 10/08/2011 09:06 User
num CC 9 10/08/2011 09:06 User
num CC 10 10/08/2011 09:06 User
num CC 11 10/08/2011 09:06 User