Two columns

  • Thread starter Thread starter Aaron Neunz
  • Start date Start date
A

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
 
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
RobFMS said:
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.
Click to expand...

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

Set ColumnA = ColumnA & ColumnB
 
Back
Top