Hello, I have never used MS access and now I need to merge to two columns into one, The first colum is the firstname (ie John) and the second column is the lastname, (ie smith) and I need to get first and last names in one column. Please give me step by step.

Email me at curt6208@sc.rr.com or post it here.

Note: Using Access 2007

Why do you need to merge them? If you need the full name in a form or report, all you have to do is put them together:

FullName: [FirstName] & " " & [LastName]

Ok let me explain it differently, i am transfering my phonebook from one phone to another, and they use .mdb files. On one of my phonebooks ( the one I want to get my contacts from) they have the fields setup as Firstname and lastname. on the phone I want to transfer to its just display name (first and last).

So I need to manually open up both of the files and copy the names, numbers ect. The names is the only problem. So please explain where I type in the command and what to type in.

Hi,

Try using query,

Insert into Phone(Name) SELECT Contacts.FirstName & " " & Contacts.LastName as Name
FROM Contacts;

How do even apply that to the table?

Please give me step by step.

Email me at curt6208@sc.rr.com or post it here.

Note: Using Access 2007Curt,

That really sounds like you are expecting help. Please don't do that. It turns people off. As with regard to your question, look up queries in the help menu. You are going to want a MAKE TABLE query. Insert all of the fields from your old "phonebook" table into the query, and substitute the first and last name fields with:[firstname] & " " & [lastname] AS [Full Name]it's that simple. the help menu will tell you how to make a MAKE TABLE query