Concatenate two strings

M

mwill

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

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]
 
Top