combining 2 fields into one

[inbal]

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?

 

[Brianwarnock]

You can concatenate data with the &

newfield = field1 & " " & field2

Brian

 

[John Big Booty]

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.

 

[boblarson]

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.

I highly agree with that statement!

 

[inbal]

i need the combined field to appear in a combo
tnx a lot for your help

 

[John Big Booty]

You can create a query that will concatenate the names and also populate you combo. There is simply no need to store concatenated data.

 

[John Big Booty]

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.

 

[inbal]

how do i do it?

 

[John Big Booty]

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.

 

[inbal]

i did it!
thanks!

 

[John Big Booty]

Good work, congratulations