How do I combine "First Name", "Last Name" Fields into a "Name" Fi

[Guest]

I have two tables one has First Name and Last Name fields. The other has
first and last names combined in a "Name" Field. I would like to combine
tables via a query for sorting and mailing purposes. This problem sounds so
simple, but it is beyond me!!!!!

Please help!

 

[Jeff Boyce]

Create a new query. In design view, add the table that has both, then in a
"field" on the grid, add something like:

FullName: [FirstName] & " " [LastName]

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff You have me on the right track. AHow do I get a space between the
FirstName and the LastName. I see the " " you have added, but Access tells me
that it is a syntax error. Is there a value I should put in the quotes?

Thank You for your reply.

Create a new query. In design view, add the table that has both, then in a
"field" on the grid, add something like:

FullName: [FirstName] & " " [LastName]

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have two tables one has First Name and Last Name fields. The other has
first and last names combined in a "Name" Field. I would like to combine
tables via a query for sorting and mailing purposes. This problem sounds
so
simple, but it is beyond me!!!!!

Please help!

 

[fredg]

Jeff You have me on the right track. AHow do I get a space between the
FirstName and the LastName. I see the " " you have added, but Access tells me
that it is a syntax error. Is there a value I should put in the quotes?

Thank You for your reply.

Create a new query. In design view, add the table that has both, then in a
"field" on the grid, add something like:

FullName: [FirstName] & " " [LastName]

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have two tables one has First Name and Last Name fields. The other has
first and last names combined in a "Name" Field. I would like to combine
tables via a query for sorting and mailing purposes. This problem sounds
so
simple, but it is beyond me!!!!!

Please help!

Jeff inadvertently left off an Ampersand.

FullName: [FirstName] & " " & [LastName]

 

[Jeff Boyce]

Thnaks, Fred.

As you mgiht notiec, my fat fngiers don't alwyas wrk <g>

Jeff

Jeff You have me on the right track. AHow do I get a space between the
FirstName and the LastName. I see the " " you have added, but Access
tells me
that it is a syntax error. Is there a value I should put in the quotes?

Thank You for your reply.

Create a new query. In design view, add the table that has both, then
in a
"field" on the grid, add something like:

FullName: [FirstName] & " " [LastName]

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have two tables one has First Name and Last Name fields. The other has
first and last names combined in a "Name" Field. I would like to
combine
tables via a query for sorting and mailing purposes. This problem
sounds
so
simple, but it is beyond me!!!!!

Please help!

Jeff inadvertently left off an Ampersand.

FullName: [FirstName] & " " & [LastName]