Not sure if this is the right sub-forum, but I have a issue with 3 employees who have apostrophes in their names.
I have a table for "Employee List" with a field for last name.
I have a 2022 Uniform Order Table with a matching last name field.
I have an query to merge last first and middle name driven by this "FullName: [LastName] & ", " & [FirstName] & " " & [MiddleInitial] & [Suffix]"
The form to write to the table uses this as its Row Source "SELECT [2022EmployeeNameQuery].FullName, [2022EmployeeNameQuery].[Employee ID] FROM 2022EmployeeNameQuery; "
When selecting the name from the form its not actually writing to the record it should. I know it's an issue with the apostrophes (As they are the only 3 of 219 employees with an issue)
I am "self"-taught in access via trial-and-error mixed with forums and YouTube. How messed up did I make myself, and what can I do to fix this. Thanks in advance for all your help.
--RC