Adding the data of two columns together.

R

Roman B.

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
 
K

kingston via AccessMonster.com

Use a calculated field in your query:

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