I'm creating a report in my DB and for the name, I'd like to have the format be "LNAME, FNAME". The problem is that in the table, I have LNAME and FNAME as 2 seperate fields.
How can I create a report that will give the last name, comma/space, and first name so that it trims the text box down to the length of the text?
I hope that makes sense.
How can I create a report that will give the last name, comma/space, and first name so that it trims the text box down to the length of the text?
I hope that makes sense.