Appending Several Fields to same target

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a way I can append text data from say 3 different
fields in the source table to the same field in the target
table.
 
If you mean you want to take FieldA, FieldB, and FieldC and put them all into
Field A of the target table, then yes it can be done. It is a little hard to
tell you exactly what to do without knowing all the details. But if you know
how to make an append query and are using the query grid you would make a
calculated field

Field: FieldA & " " & FieldB & " " & FieldC
Table: Blank
Destination: TableTarget.FieldA
 
That did it. Thanks a lot. John
-----Original Message-----
If you mean you want to take FieldA, FieldB, and FieldC and put them all into
Field A of the target table, then yes it can be done. It is a little hard to
tell you exactly what to do without knowing all the details. But if you know
how to make an append query and are using the query grid you would make a
calculated field

Field: FieldA & " " & FieldB & " " & FieldC
Table: Blank
Destination: TableTarget.FieldA


.
Click to expand...
 
Back
Top