Upper Case in SQL View

[stretch]

Hi all

I have a DB which uses a union query. The DB is based on 3 tables.
Everything works fine except -

The 3 tables have the format property set to > (to force upper case output)

This works fine on all my other queries, but on the Union Query, all the data comes out exactly as it was input. (!!!)

Is there a way to get the Union Query to do the same thing - obviously the Union Query is in SQL - and I struggle with that at the best of times !!

Here is my code for the Union Query:

SELECT CDTS.[Student No], CDTS.Rank, CDTS.Name, CDTS.Initial, CDTS.Sqn, CDTS.[M/F], CDTS.[18+], CDTS.Course, CDTS.Paid, CDTS.Notes, CDTS.Attended, CDTS.Hut, CDTS.Result
FROM CDTS;

UNION SELECT DS.[Serial], DS.Rank, DS.Name, Null, DS.Sqn, DS.[M/F], Null, DS.Course, Null, Null, DS.Attended, DS.Hut,Null
FROM DS;

UNION SELECT STAFF.[Student No], STAFF.Rank, STAFF.Name, STAFF.Initial, STAFF.Sqn, STAFF.[M/F], Null, STAFF.Course, STAFF.Paid, STAFF.Notes, STAFF.Attended, STAFF.Hut, STAFF.Result
FROM STAFF;

Hope someone can help with this..

Stretch

 

[Dugantrain]

The easiest way to do this is to base a query off of your Union Query and do your formatting there.

 

[stretch]

The easiest way to do this is to base a query off of your Union Query and do your formatting there.

Many thanks - that worked perfectly !! Job Done !!