M mwill May 4, 2004 #1 I would like to combine my firstname and lastname fields on a report. How do I write this query/use the concatenation function?
I would like to combine my firstname and lastname fields on a report. How do I write this query/use the concatenation function?
C Cheryl Fischer May 4, 2004 #2 Create a textbox in your report's design layout and name it something other than the name of a bound field in your report. In the ControlSource property of the textbox, enter: =[FirstName] & " " & [LastName]
Create a textbox in your report's design layout and name it something other than the name of a bound field in your report. In the ControlSource property of the textbox, enter: =[FirstName] & " " & [LastName]
