Join 3 Fields to make 1 Field

[Heather]

Hello-

I need to join 3 fields together to make New field.
Field 1 = 1
Field 2 = 22
Field 3 = 5

New Field = 1225

Thanks

 

[Jeanette Cunningham]

Hi Heather,
in your table create a new field and call it F4.

Create a query based on the same table and drag the field called F4 on to
the query grid.
Change the query to an update query.
In the Update to row type
[TableName].[Field 1]& [TableName].[Field 2]& [TableName].[Field 3]
Now click the run icon on the menu/ribbon.

Replace TableName with the name of the table, and Field 1 etc with the name
of each field.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[John W. Vinson]

Hello-

I need to join 3 fields together to make New field.
Field 1 = 1
Field 2 = 22
Field 3 = 5

New Field = 1225

Thanks

Jeannette's given you the answer... but let me give you a question.

WHY?

Storing data redundantly is a bad idea.
Storing data redundantly and ambiguously is an even WORSE idea: what result do
you want if Field1 is 12, Field2 is 2, and Field3 is 5? Is it OK that it gives
you exactly the same result as your example? It will do so.

What's the context? It may be legitimate to do this... but you're tiptoeing
through a minefield.