Adding the data of two columns together.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns I need to add the data together and place into a third
column.

for example.

Column 1 says - widget
Column 2 says - 002

I would like column three to say "widget-002" so I need to add a "-" as well.

Can someone show me how to do this? This would be a great help in saving me
time.

Thanks
Roman
 
Use a calculated field in your query:

Field3: [Field1] & "-" & [Field2]
 

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

Query - Show One of Everything 3
Excel Comparing two columns 1
VBA - retrieve data on last create named range from previous inserted named range 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Overlay two queries into one chart 3
how do i perform a Count(Distinct) query for 2 different column va 1
Excel 2013: AutoFilter and SUM() 1
Excel 2013 1

Back
Top