Concatenate two strings

  • Thread starter Thread starter mwill
  • Start date Start date
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?
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate field in table 2
concatenation 3
Table Concatenate Fields Access 2007 1
Concatenate FullName based on whether a field is empty. 8
Concatenation 1
How to stack fields on Access report 3
Displaying two fields in combo box 8
Query 2

Back
Top