joining 2 fields into 1


G

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?
 
Ad

Advertisements

M

Mythran

dawnnolan said:
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
 
M

Mythran

dawnnolan said:
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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top