Syntax for concatenated fields and strings

[Joseph Misko]

I am creating a report based on a table. I was sure that before I have
entered this into the field's source on the report and gotten what I want:

=[FirstName] & " " & [LastName]

However, now that just gives me an error. I've tried a few combinations,
but all give me an error. It seems like this should be straightforward and
not need a query. Can anyone give me the syntax hints?

Thanks,
Joe

 

[Fons Ponsioen]

Make sure that the name of the text box is not the name of
either of the variables. For instance if the name of the
box is FirstName you could change it to FirstName1. This
should fix the problem.
Take care.
Fons

 

[Lynn Pennington]

Thanks - it helped me. Lynn.

-----Original Message-----
Make sure that the name of the text box is not the name of
either of the variables. For instance if the name of the
box is FirstName you could change it to FirstName1. This
should fix the problem.
Take care.
Fons

-----Original Message-----
I am creating a report based on a table. I was sure

that
before I have

entered this into the field's source on the report and gotten what I want:

=[FirstName] & " " & [LastName]

However, now that just gives me an error. I've tried a few combinations,
but all give me an error. It seems like this should be straightforward and
not need a query. Can anyone give me the syntax hints?

Thanks,
Joe


.

.