help with concatinating??

[claudia_lovez_u]

Hi I'm trying to concatinate 2 text boxes on a report and this is the syntax I'm
using = (fldFName) &’ ‘& (fldLName) i have also tried it with brakets: =
[fldFName] &’ ‘& [fldLName] and it doesn't work. I get a message saying
the expression you entered has a invalid sintax.


I need help plz!! this is
for my homework
Thank you

[alansidman]

You are trying to put a space between the two fields?

Try this: = (fldFName) &" "& (fldLName)

Use the double quotes with a space between them.

[Bob Fitz]

Have you tried:
= (fldFName) & " " & (fldLName)

[claudia_lovez_u]

Thank you for the response it work! but it only does it to the first field on each group, how can I make it so it will be in all the fields?

You are trying to put a space between the two fields?

Try this: = (fldFName) &" "& (fldLName)

Use the double quotes with a space between them.

[alansidman]

Suggest you do the concatenation in a query and make the query your record source for your report. Easier to manipulate if you do it in a query.