DB Field format is LName, FName (Single field 'NAME') - need report to read FName, LName - is there a command for that?
I have a report that needs to pull a contact name in the format of FirstName, LastName - the field in the DB is a single field 'NAME' formatted in LastName, FirstName - is there a way to flip the test on each side of the comma and achieve this? All assistance is appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER