• Thank you for the additional suggestion! I can't tell you how much I appreciate it. I'm still learning SQL and have a long way to go it seems.

    Yes, I sort using literal terms due to using several UNION commands to join several similar queries. An example of the reason is in query 1, the address is in a field called "Address", but in query 2 it is called "DestAddress". So, I just map each to the same field name and sort on that name. It may not be the best way, but it's the only way I could make it work. If there's a better way, I'd love to know it.

    Thanks again!

    Robert