I am trying to create a union query. It will be a list of all the customers in the database. The list will be first LastName, FirstName and then FirstName, LastName.
Any idea why the below code isn't working?
FROM ([Customer Info Table])
SELECT CustomerID, [LastName] & ", " & [FirstName] as [FullName], 1 as Seq
FROM [Customer Info Table]
SELECT CustomerID, [FirstName] & " " & [LastName] as [FullName], 2 as SEQ
ORDER BY UnionName.SEQ, UnionName.FullName