Merging data

[Guest]

I have a very basic access database established. I need to merge for example
columns 1, 2, 3, & 4. I would like to see the data in the following format
(1.11.21.A) in column 5, how do I accomplish this miraculous feat?

 

[Jason Lepack]

Assuming that your data is like this:
A,B,C,D
1,11,21,A

Then put this formula in E1:
=A1&"."&B1&"."&C1&"."&D1

Cheers,
Jason Lepack

 

[Joseph Meehan]

Assuming that your data is like this:
A,B,C,D
1,11,21,A

Then put this formula in E1:
=A1&"."&B1&"."&C1&"."&D1

Note: the formula should be used in queries, forms and reports, but it
should not be used to fill a new field in a table. Don't store the result.