Avatar of Mike Rudolph
Mike RudolphFlag for United States of America

asked on 

Concatenate First name & Last name on report

Hello Experts,

Okay, need a little help with this one.

I want to concatenate the firstname and lastname fields on my report to display the following format:
Lastname, Firstname

I could do this easily by generating a query, concatenate the string in the query and using the query as the datasource for my report. But I do not want to create a query simply because I cannot concatenate two fields on my report. I could do this in snap using Crystal (just drag two fields into a textbox) but this feature is not available in Access.

So my question is how can I concatenate two strings directly on the report. Is it possible? I am kind of in a time crunch on this one so I am offering 500 pts.
Thanks!
Microsoft Access

Avatar of undefined
Last Comment
frankytee
ASKER CERTIFIED SOLUTION
Avatar of frankytee
frankytee
Flag of Australia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Mike Rudolph
Mike Rudolph
Flag of United States of America image

ASKER

frankytee,

Yep, that worked!!!

=[Student_Lname] & ",  " & [Student_Fname]

Thanks a bunch!
Avatar of frankytee
frankytee
Flag of Australia image

thanks, you're welcome.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo