joining 2 fields into 1

[Guest]

I am new to access and am trying to create a query that joins the first and
last name in a table to create a new field called fullname that has the first
and last name together. How do I do this?

 

[Mythran]

I am new to access and am trying to create a query that joins the first and
last name in a table to create a new field called fullname that has the
first
and last name together. How do I do this?

select LastName & ", " & FirstName from tblMyTable

HTH,
Mythran

 

[Guest]

Whenever I try to create a new field, it keeps telling me invalid expression.

 

[Mythran]

Whenever I try to create a new field, it keeps telling me invalid
expression.

In a query or table? Post what you currently have for the query, if it is a
query.

Mythran

 

[Guest]

Hi Dawn

I have a field that does what you want and I have the code in the Form Load
for form it is:

txtCustName = txtTitle & " " & txtFirstname & " " & txtLastname

the "" have a space between them, I believe you could also type the code
into the field you want the data to appear but put an = sign before it.

Hope it helps you, if not sure some else here will correct me.

Saj