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

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

you need to concatenate the two fields, as

FullName: FirstName & " " & LastName

hth


"thjofe" wrote in message
...
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

thjofe wrote:

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

--
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.

Please help.

"tina" wrote:

you need to concatenate the two fields, as

FullName: FirstName & " " & LastName

hth


"thjofe" wrote in message
...
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

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" wrote:

thjofe wrote:

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

--
Marsh
MVP [MS Access]

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]


thjofe wrote:
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.


thjofe wrote:
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?


"Marshall Barton" wrote:
Just use a calculated field in the query:

FullName: FirstName & " " & LastName

thanks for your help

"Marshall Barton" wrote:

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]


thjofe wrote:
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.


thjofe wrote:
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?


"Marshall Barton" wrote:
Just use a calculated field in the query:

FullName: FirstName & " " & LastName