How do I combine data from two fields into one using a query?

[Guest]

I am working on a project and there is an existng table which includes a
FirstName and a LastName field. I am trying to design a query to include the
data from both these fields in one column with a space in between them and a
different heading when the query is run.

How do I design that part of the query to provide the information I need in
the desired format?

I am using Access 2003

Thank you

 

[tina]

you need to concatenate the two fields, as

FullName: FirstName & " " & LastName

hth

 

[Marshall Barton]

I am working on a project and there is an existng table which includes a
FirstName and a LastName field. I am trying to design a query to include the
data from both these fields in one column with a space in between them and a
different heading when the query is run.

How do I design that part of the query to provide the information I need in
the desired format?

Just use a calculated field in the query:

FullName: FirstName & " " & LastName

 

[Guest]

I did that but now a popup box appears and asks me to enter a parameter for
both the first and last name. I don't understand. Could you please elaborate
on the "concatenate" part of your response. I am getting the desired output
but with the popup box I leave it blank and the entire column is left blank
instead of showing the two names combined.

Please help.

 

[Guest]

I did that but now a popup box appears and asks me to enter a parameter for
both the first and last name. I don't understand. Could you please elaborate
on the "concatenate" part of your response. I am getting the desired output
but with the popup box I leave it blank and the entire column is left blank
instead of showing the two names combined.

Please help.

 

[Marshall Barton]

There's nothing wrong with the concatenation. When you are
prompted for a value, it means that the thing you are
prompted for is not available in the query's table.

In this case, it probably means that you misspelled the
names of the fields. Check them carefully, they must be
**exactly** the same as the fields in the table.

 

[Guest]

thanks for your help

There's nothing wrong with the concatenation. When you are
prompted for a value, it means that the thing you are
prompted for is not available in the query's table.

In this case, it probably means that you misspelled the
names of the fields. Check them carefully, they must be
**exactly** the same as the fields in the table.
--
Marsh
MVP [MS Access]

I did that but now a popup box appears and asks me to enter a parameter for
both the first and last name. I don't understand. Could you please elaborate
on the "concatenate" part of your response. I am getting the desired output
but with the popup box I leave it blank and the entire column is left blank
instead of showing the two names combined.