If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appending Several Fields to same target
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 John wrote: 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. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to ignore fields in Update Query | Casa | Running & Setting Up Queries | 6 | July 12th, 2004 12:46 AM |
Import to custom fields in contacts | jdh | General Discussion | 1 | July 2nd, 2004 07:08 PM |
UNION Query truncating Memo fields | Matthew DeAngelis | Running & Setting Up Queries | 4 | June 10th, 2004 02:17 PM |
Lookup fields on label report | Howard | Setting Up & Running Reports | 1 | June 3rd, 2004 02:43 AM |
Calculating fields for Access | Galin | New Users | 6 | May 5th, 2004 12:05 AM |