Display Only Uppercase

[rpeare]

Your query is only looking at given name. To get Upper Case you would have this query:



SELECT UCase([GIVEN_NAME]) AS Given_Name_Conv
FROM [Standard Format];

to show lower case you would have:

SELECT LCase([GIVEN_NAME]) AS Given_Name_Conv
FROM [Standard Format];

To show both in the same query you would have:

SELECT LCase([GIVEN_NAME]) AS Given_Name_Conv
FROM [Standard Format]
UNION ALL
SELECT UCase([GIVEN_NAME]) AS Given_Name_Conv
FROM [Standard Format]

[orange]

Maybe we're all still missing what your problem is James.
Here are a couple of links that should help understand Ucase and LCase, the syntax and usage examples.

http://www.techonthenet.com/access/f...ring/Ucase.php UCase
http://www.techonthenet.com/access/f...ring/lcase.php LCase

Good luck.