combining 2 fields into one

I

inbal

Registered User.
Local time
Yesterday, 16:35
Joined
Feb 8, 2009
Messages
48
I have two tables.
the first has sir name and family name as 2 different fields.
the second has full name as 1 field.
I want the second table to show the names from the first table but in one field.
is it possible?
 
You can concatenate data with the &

newfield = field1 & " " & field2

Brian
 
It's certainly possible as Brianwarnock has shown; but why would you want to store the data again, concatenated? Why not simply store an ID number and only concatenate, the fields as require, for display purposes, on your form/report.

It becomes a very difficult task to Un-concatenate fields should it be required.
 
John Big Booty said:
It's certainly possible as Brianwarnock has shown; but why would you want to store the data again, concatenated? Why not simply store an ID number and only concatenate, the fields as require, for display purposes, on your form/report.

It becomes a very difficult task to Un-concatenate fields should it be required.
Click to expand...

I highly agree with that statement!
 
i need the combined field to appear in a combo
tnx a lot for your help
 
You can create a query that will concatenate the names and also populate you combo. There is simply no need to store concatenated data.
 
Here's an example DB. Check what is displaying in the combo box, now check what is stored in the two tables. To see how it's done check out the query.
 

Attachments

The query that populates the Combo does all the work. There is only one query in the DB, so have a look at how it is constructed.
 
You must log in or register to reply here.

Similar threads

I
Combine and sum data from a form to a report
Replies
1
Views
151
pbaldy
pbaldy
R
Unique values
Replies
15
Views
574
Pat Hartman
P
K
How to remove duplicate values when multiple tables are joined
Replies
18
Views
1,145
Pat Hartman
P
E
Importing Specific Field Names From Excel into Access Table
Replies
12
Views
580
Pat Hartman
P
R
Solved Import Excel file into existing table with an autonumber primary key field
Replies
6
Views
336
Isaac
Isaac

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom