Two columns

[Aaron Neunz]

I have two columns in my table, A & B (970 rows)

I need to take the contents of Column B and append them to Column A without
replacing the contents of Column A. How do I write the query??


Thanks in Advance,
Aaron Neunz

 

[RobFMS]

Update <tablename>
Set ColumnA = ColumnA & " - " & ColumnB

This is assuming that Column A is of type Text or Memo and the correct size
is available to put all the contents in Column A.

--
Rob

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

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

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

 

[Joseph Meehan]

Update <tablename>
Set ColumnA = ColumnA & " - " & ColumnB

This is assuming that Column A is of type Text or Memo and the correct
size
is available to put all the contents in Column A.

Note: This formula will result in adding a "-" between the two parts.
If that is not what you want try:

Set ColumnA = ColumnA & ColumnB

 

[juanfernandez]

Update <tablename>
Set ColumnA = ColumnA & " - " & ColumnB

This is assuming that Column A is of type Text or Memo and the correct size
is available to put all the contents in Column A.

--
Rob

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

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

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