Combining Text Values in a Report

[cfwillia]

I'm trying to make a field in my report (pulling from a query) that will list all of the text in several fields separated by commas.

I have a text box where the control source is:

=[CA772N] & ", " & [CA772EPN] & ", " & [CA772IDN] & ", " & [CA772GCN] & ", " & [CA772PRN]

All it gives me is "#error" when I run the report, and this doesn't make sense cause it follows the format given in the help menu (=[Address]&", "&[City]&" "&[Region]&" "&[PostalCode] ).

Thanks!

[dima69]

I'm trying to make a field in my report (pulling from a query) that will list all of the text in several fields separated by commas.

I have a text box where the control source is:

=[CA772N] & ", " & [CA772EPN] & ", " & [CA772IDN] & ", " & [CA772GCN] & ", " & [CA772PRN]

All it gives me is "#error" when I run the report, and this doesn't make sense cause it follows the format given in the help menu (=[Address]&", "&[City]&" "&[Region]&" "&[PostalCode] ).

Thanks!

Maybe it sounds trivial, but make sure you spell the field names correctly, each field name is unique in your query, and that the names of the fields do not conflict with the names of report controls.

[MMcCarthy]

Are all the fields of fieldtype text?


Mary