Syntax for concatenated fields and strings

  • Thread starter Thread starter Joseph Misko
  • Start date Start date
J

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
 
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
 
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
Click to expand...
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


.
Click to expand...
.
Click to expand...
 
Back
Top