Access query to combine table fields

Open the query in design view
In the Lower section, in the Field of teh column where you want to display the joined fields type the formula
Example
Fieldname:[First Name] & [Last Name]
or
Fieldname:[First Name]&" " & [Last Name] (if you need space between the two.
Where First Name and Last Name are two existing fields that you want to join

Just to clarify, is Table2 what you want?

Table1
A B C D E
1 2 3 4 5

Table2
A1 B2 C3 D4 E5

If so - then one way of doing this is to use an UPDATE query - but you'll need to identify a relationship between the rows (primary key?) to determine which rows (even though there's only two) contain the values to 'combine'.

You might try creating a query with this info:

Combined: [FieldA] & [FieldB] & [FieldC]...etc.

You can enter this directly in the query design mode and it will combine the contents. If you want to add anything between them, include this between your fields: & "-" &

HI,
The sure way to get the definitive answer is to email the author of my University database course. The guy is very funny !! (And also writes great books)
His email is : rwatson@terry.uga.edu
That's your best bet !!
John