I am simply trying to add a selection in a combo box that says "Add New Personnel" that's located at the top of the list and for some reason I can't seem to nail down the syntax of what I am doing wrong. Access does not seem to be helping me either with it's arbitrary error's.
I would greatly appreciate any help on figureing out what the problem is in the below SQL Statement.
SELECT "-1" as [Personnel.ID], "(Add New Personnel)" as [FullName] FROM Personnel UNION SELECT "0" as [Personnel.ID], [Last Name] & ", " & [First Name] & " " & [MI] AS FullName, Personnel.Badge, [Badge Colors].[Badge Color], Personnel.Phone FROM Personnel INNER JOIN [Badge Colors] ON Personnel.[Badge Color] = [Badge Colors].ID ORDER BY [Last Name] & ", " & [First Name] & " " & [MI];
Thanks again for the help and time!