I am having trouble concatenating a field from an employee table where the format is "Last name, a comma, a space, first name." I attached a screen shot of my database. Thanks for the help!
I am having trouble concatenating a field from an employee table where the format is "Last name, a comma, a space, first name." I attached a screen shot of my database. Thanks for the help!
I don't see any screen print, but perhaps this is what you are looking for?
FullName: [LastNameField] & ", " & [FirstNameField]
Thank you, That did work