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!
ASKER
Yep, that worked!!!
=[Student_Lname] & ", " & [Student_Fname]
Thanks a bunch!