Concatenate 2 table columns into 1 report field 2

[andyb2005]

I have a table with firstname and surname fields and what I'd like to be able to do is to concatenate the two fields into one field in my ms-access report.

Have had a search for how to do this but haven't found the answer as yet! Any help appreciated!

 

[FancyPrairie]

Set you recordsource of the Report to a query. In the QueryDesign mode, select all of the fields you want included in the report and then add one that looks like this:

FullName: [FirstName] & " " & [SurName]

 

[DJN]

In your query, create another field, CombinedNames:[FirstName] & " " & [LastName]

 

[andyb2005]

Thanks guys!

Works great!