Simple but stuck

  • Thread starter Thread starter myxmaster
  • Start date Start date
M

myxmaster

I have placed the following in a textbox in the report footer
=[firstname] & [Last Name]. When I refer to it in the report header it
reads JohnSmith with no spacing. I have tried enclosing the "&" . How
do I make a space between the first and last name.
TIA
 
=[firstname] & " " & [Last Name]

I have placed the following in a textbox in the report footer
=[firstname] & [Last Name]. When I refer to it in the report header it
reads JohnSmith with no spacing. I have tried enclosing the "&" . How
do I make a space between the first and last name.
TIA
 
I have placed the following in a textbox in the report footer
=[firstname] & [Last Name]. When I refer to it in the report header it
reads JohnSmith with no spacing. I have tried enclosing the "&" . How
do I make a space between the first and last name.
TIA

=[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

Back
Top