General discussion

Locked

Access query to combine table fields

By hersheyboy ·
How do I construct an Access query to combine table fields

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ichu50 In reply to Access query to combine t ...

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

Collapse -

by hersheyboy In reply to

maybe I used the wromg word by saying combine. I have a table with 5 pairs of like fields. I want to merge the contents of each pair of fields so that I end up with 5 fields which are twice as long.

Collapse -

by timfox In reply to Access query to combine t ...

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

Collapse -

by Bristar In reply to Access query to combine t ...

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: & "-" &

Collapse -

by asjwm2 In reply to Access query to combine t ...

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

Collapse -

by hersheyboy In reply to Access query to combine t ...

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums