how to merge two data fields together?

[Nadalia]

I work on the database someone else created. Now I want to merge two data fields into one. How do that?

Thanks for any help!

 

[ReAn]

What do you mean?

Like 2 text fields into one?

Make a new field in your table to hold the merged information. Then make an update query as follows: "UPDATE tblMyTable SET tblMyTable.MERGEDFIELD = [FIELD1] & [FIELD2];"

 

[Nadalia]

ReAn, that is what I mean, merge two text fields into one. I will try what you told. Thank you so much!

Nadalia

 

[Nadalia]

What do you mean?

Like 2 text fields into one?

Make a new field in your table to hold the merged information. Then make an update query as follows: "UPDATE tblMyTable SET tblMyTable.MERGEDFIELD = [FIELD1] & [FIELD2];"

Thanks RenAn, it worked like a magic!

 

[ReAn]

No Problem, glad it helped.

 

[sconly]

it does work, but how can i put a space between the results in the merge field.

 

[Mile-O]

"UPDATE tblMyTable SET tblMyTable.MERGEDFIELD = [FIELD1] & Chr(32) & [FIELD2];"