How do I combine 2 fields into 1

[NickTheBatMan]

I am pretty much a total novice.

I am having to work with someone elses database.

I have imported a load of names and phone numbers in LastName
FirstName format into one table.

I want to combine LastName & FirstName into Name in the same table and
delete LastName FirstName without disturbing the phone numbers...

Help please !

TIA

Nick

 

[Allen Browne]

Create a query using this table.

Type an expression like this into the Field row in query design:
FullName: [LastName] & ", " + [FirstName]

You can now use that query anywhere that you want the combined names.

Do not change the way the table itself works. One of the basic rules of data
design is to make your fields atomic, i.e. don't store 2 things in the one
field.

 

[NickTheBatMan]

Create a query using this table.

Type an expression like this into the Field row in query design:
    FullName: [LastName] & ", " + [FirstName]

You can now use that query anywhere that you want the combined names.

Do not change the way the table itself works. One of the basic rules of data
design is to make your fields atomic, i.e. don't store 2 things in the one
field.

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


 

I am pretty much a total novice.

I am having to work with someone elses database.

I have imported a load of names and phone numbers in LastName
FirstName format into one table.

I want to combine LastName & FirstName into Name in the same table and
delete LastName FirstName without disturbing the phone numbers...

Help please !

Nick- Hide quoted text -

- Show quoted text -

Most excellent Allen, thank you

 

[Eduardo Cotes]

I am pretty much a total novice.

I am having to work with someone elses database.

I have imported a load of names and phone numbers in LastName
FirstName format into one table.

I want to combine LastName & FirstName into Name in the same table and
delete LastName FirstName without disturbing the phone numbers...

Help please !

TIA

Nick