If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding the data of two columns together.
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 |
#2
|
|||
|
|||
Adding the data of two columns together.
Use a calculated field in your query:
Field3: [Field1] & "-" & [Field2] Roman B. wrote: 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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|