I have a Union Query in my Access 2003 DB that is combining two tables for a complete list of "Employees" and "Non-Employees". Both of the separate tables are set in the "Format" with a ">" for Last Name and First Name. So, when I open the tables directly, the First and Last Name fields are all Caps. However, when I run the Union Query to achieve a combined list, the names are no longer capitalized. When setting up the Union Query, it forces you to use SQL instead of Access' pretty GUI setup screen, and I am unfamiliar with SQL coding or how to alter the code below so that these fields stay capitalized. Can anyone help me with this? I don't care if every field in the Union Query is capitalized. So, a blanket statement would work just as well as something that specifies the individual fields for the name.
SELECT [KEY#], [LSTNAME], [FSTNAME], [DOH], [HOMEDEPT], [EMPTYPE], [LOOKUP_TAG]
UNION SELECT [KEY#], [LSTNAME], [FSTNAME], [DOH], [HOMEDEPT], [EMPTYPE], [LOOKUP_TAG]
ORDER BY [LSTNAME];