How do I combine data from two columns into one in Access 2007

  • Thread starter Thread starter WildeYam
  • Start date Start date
W

WildeYam

I would like to merge the data from two separate columns and create a new
column with the joined information, ie: field 1 contents to be joined with
field 2 contents to create a new field showing field 1+field 2. I need help
figuring out how to do that. Thanks
 
Create a query like this

SELECT field1, field2, field1 + field2 as field3 FROM table

If your fields are numeric use the + operator. If you want to concatenate
two strings then you must use the & operator.

Any reports or further queries can refer to this new query with the new
field created.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Mismatch in Excel 2010 4
Separation of Combination Data 1
How do I concatenates two fields into one field in the same table? 3
Turning a 3 column flat file into a "3D" Table 2
Join a field two records 6
Combining records in access 2007 4
How do I create a date from data in seperate columns 2
Strange Asian looking characters in output 3

Back
Top