copy values

[Guest]

I have a set of values in three columns: a, 1,1 a,2,4 a,3,2 . Now I want
to copy the values in columns 2 and 3 to another letter: b,1,1 b,2,4
b,3,2. Would you do that with a "For Each" and how would you write the
iteration?

 

[RobFMS]

Insert Into table1 (Field1, Field2, Field3)
SELECT "b" AS Field1, table1.Field2, table1.Field3
FROM table1
WHERE (((table1.Field1)="a"));

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Guest]

Thanks. I'm a fan of FMS Access Analyzer, by the way.
Sam

 

[RobFMS]

We appreciate the good word!

Thanks,

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-