Name Query

[jimd1768]

I am sorry this is such a basic question but I am stuck and require your expertise.

I have 2 fields for customers:
FirstName
LastName

I was trying to run a query that will give me the full name. Instead of having:
John
Smith

I would like:
John Smith

I hope this makes sense.

Thank you in advance

 

[MStef]

Look at "DemoFullNameQryA2000.mdb" (attachment, zip).
Run Query1.

 

[namliam]

Make a new field:
FullName: [FirstName] & " " & [LastName]

 

[jimd1768]

Thank you very much. Sorry for such a simple question.
Greatly appreciated