Add comma after last name in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that I use to send bday cards. I'd like a comma after the
last name, to appear immediately after the last letter of the last name. How
do I do this?
 
In addition to Al's reply, make sure the name of the text box is not the
name of a field in the report's record source. For instance, if the text box
name is "LastName", change it to "txtLastName".

--
Duane Hookom
MS Access MVP


Al Camp said:
Use Concatenation...
= [LastName] & ","
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

franklinbukoski said:
I have a report that I use to send bday cards. I'd like a comma after the
last name, to appear immediately after the last letter of the last name.
How
do I do this?
Click to expand...
Click to expand...
 
Duane, that did it, I got an error message, and now I know why. Thank you!
This website has helped me a great deal in the workplace.

Duane Hookom said:
In addition to Al's reply, make sure the name of the text box is not the
name of a field in the report's record source. For instance, if the text box
name is "LastName", change it to "txtLastName".

--
Duane Hookom
MS Access MVP


Al Camp said:
Use Concatenation...
= [LastName] & ","
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

franklinbukoski said:
I have a report that I use to send bday cards. I'd like a comma after the
last name, to appear immediately after the last letter of the last name.
How
do I do this?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top