microsoft.public.access

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.

"Jeff Boyce" wrote:

> 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
>
>
> "Climberjon" wrote in message
> news:176C54C9-A07B-4B58-9417-C272B5A6BBF6@microsoft.com...
> >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!
>
>
>