Merge fields to a new field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...


In a query?
NewColumn:[FieldA] & " " & [FieldB] & " " & [FieldC]
 
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.
Click to expand...

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]
 
How can I add spaces between fields?

Jeannette

John Vinson said:
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.
Click to expand...

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]
Click to expand...
 
Lump: [FieldA] & " " & [FieldB] & " " & [FieldC]


jeannette_rivera said:
How can I add spaces between fields?

Jeannette

John Vinson said:
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.
Click to expand...

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]
Click to expand...
Click to expand...
 
How can I add spaces between fields?
Click to expand...

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

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


John W. Vinson[MVP]
 
Back
Top