Everything works fine with the Query, however, I would like to know how to add SELECT UCASE( ) to the SELECT "Agent" and "Passenger" fields?  Any help would be greatly appreciated. Thanks!
 

=======

SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date"

FROM "August 2011"
WHERE "Agent" = 'JOHN'
UNION
SELECT "Catagory", "Agent", "Passenger", "Booking Number", "Travel Date"

FROM "September 2011"
WHERE "Agent" = 'JOHN'
ORDER BY "5"

 

=======