How to concatenate DB fields with punctuation

[rtcary]

I want to have some fields in a Report concatenate some fields e.g. "Last name, First name". I am using Access 2010 (my experience is with Access XP). Which Design object do I use and how do I specify the data fields?

My table is Members and the field names are "First name" and "Last name".

With appreciation...

Todd

[ssanfu]

FYI, should not use spaces in object names (field names, form names, query names,...)

However, in a column in a query use:

FullName: [Last Name] & ", " & [First Name]

In the report, a text box control would be bound to "FullName"

[rtcary]

Thank you for the reminder about spaces; that will definitely be corrected once I get use to the "new" Access2010 and the "ribbon". Can I place a concatenated data object on the free form Report without creating the field in the query...just use references to a Table's fields?

Thank you,

Todd

[Missinglinq]

If the Fields are included in the RecordSource for the Report you can simply create an Unbound Control on the Report and use this in its Control Source Property:

=[Last Name] & ", " & [First Name]

Linq ;0)>

[ssanfu]

AS Linq said, you can certainly use an unbound calculated control on a report; I use them a lot in headers and/or footers.
But if the calculated control is in the detail section, I have found it much easier to do the calculation (concatenation) in the query.

[Missinglinq]

...I have found it much easier to do the calculation (concatenation) in the query.

Most things are!

Linq ;0)>