Merge Data Colums

[Guest]

Hello,

I have an access data base table that has 3 colum with information and I
would like to merge the cell togather, Example (Colum 1 = 01, Colum 2 = 21,
Colum 3 = 09 make in to one Colum: 012109) I need help on how this works?

 

[Marshall Barton]

I have an access data base table that has 3 colum with information and I
would like to merge the cell togather, Example (Colum 1 = 01, Colum 2 = 21,
Colum 3 = 09 make in to one Colum: 012109) I need help on how this works?

Where/How do you want the result to be used?

It would be a bad idea to put the result in a table, so the
sensible thing to do is to only display the combined value
when users need to see it in a report (or maybe in a form).
If this is what you want, then use a text box with a control
source expression like:
=[Colum 1] & [Colum 2] & [Colum 3]

 

[John Vinson]

Hello,

I have an access data base table that has 3 colum with information and I
would like to merge the cell togather, Example (Colum 1 = 01, Colum 2 = 21,
Colum 3 = 09 make in to one Colum: 012109) I need help on how this works?

You can do this in a Query (you cannot and *should* not store the
result in any Table field).

In a vacant Query cell, type

SomeName: [Colum 1] & [Colum 2] & [Colum 3]

assuming that these are in fact the fieldnames you're using in your
table (rather odd fieldnames if you ask me, but you didn't, so...)

John W. Vinson[MVP]

 

[Guest]

In a query it would look somenthing like:

MergeData: [Colum 1] & [Colum 2] & [Colum 3]

You do not want this in the table. Just calculated it as needed in a query,
form, or report.