I am looking to merge multiple fiel 2

[th1011]

I am looking to merge multiple fields into one. Example FirstInitial, LastName, PositionNumber to One field labeled Name.
A. Thomas 12345

 

[KenReay]

Hi

Use the Concatanate operator &

so

FullName = [Title] & " " & [FirstName] & " " & [Lastname]

using your own column names of course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dodge20]

If you just want to run a query you can combine the fields like:

You may want to use the trim in front to eliminate extra spaces, here is an example.

SELECT Trim([Observation]) & " " & Trim([Observations]) AS Combined Observation FROM YourTableName;

Dodge20

 

[Golom]

If you just want to see it in a query then

   Select (FirstInitial & ' ' & 
           LastName & ' ' & 
           Format(PositionNumber,"0")) As [Name]
   From ...

If you want to create a new field in your table then add the Name field to your table in table design view and then

   UPDATE tbl SET [Name] =
          (FirstInitial & ' ' & 
           LastName & ' ' & 
           Format(PositionNumber,"0")