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

[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

 

[geoleo68]

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.

 

[WildeYam]

thanks - it worked just fine! Do appreciate the quick response.