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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

appending new records to a table with a compound primary key 9
Append to two different tables 23
Append data 3
Help with Append Query 1
q. Append Query 2
Numeric Field Overflow Error 5
Append Key Violation error 3
Append query - Append to table with Autonumber field 2

Back
Top