Merge fields to a new field

[marjac]

How do I concatenate strings from multiple fields to a new field and repeat
the action for all records in a database? I have Office 2003.

 

[fredg]

How do I concatenate strings from multiple fields to a new field and repeat
the action for all records in a database? I have Office 2003.

In a query?
NewColumn:[FieldA] & " " & [FieldB] & " " & [FieldC]

 

[John Vinson]

How do I concatenate strings from multiple fields to a new field and repeat
the action for all records in a database? I have Office 2003.

Why would you WANT to!?

You can do so dynamically, by creating a Query with a calculated
field:

Lump: [FieldA] & [FieldB] & [FieldC]

But this lump should almost certainly not be stored in any table.

John W. Vinson[MVP]

 

[jeannette_rivera]

How can I add spaces between fields?

Jeannette

How do I concatenate strings from multiple fields to a new field and repeat
the action for all records in a database? I have Office 2003.

Why would you WANT to!?

You can do so dynamically, by creating a Query with a calculated
field:

Lump: [FieldA] & [FieldB] & [FieldC]

But this lump should almost certainly not be stored in any table.

John W. Vinson[MVP]

 

[John Spencer]

Lump: [FieldA] & " " & [FieldB] & " " & [FieldC]

How can I add spaces between fields?

Jeannette

How do I concatenate strings from multiple fields to a new field and
repeat
the action for all records in a database? I have Office 2003.

Why would you WANT to!?

You can do so dynamically, by creating a Query with a calculated
field:

Lump: [FieldA] & [FieldB] & [FieldC]

But this lump should almost certainly not be stored in any table.

John W. Vinson[MVP]

 

[John Vinson]

How can I add spaces between fields?

By including them in the string concatenation, using " " - a literal
space character:

Lump: [FieldA] & " " & [FieldB] & " " & [FieldC]


John W. Vinson[MVP]