BSHELTON
Last Activity: Jul 24 '06, 04:44 PM
Joined: Jul 21 '06
Location:
-
Many thanks, I will try this. bds -
How to convert lowercase to uppercase in Access table
How do I convert existing lowercase data to uppercase in Access 2000? I used the following which did not work?
UPDATE HousingTowns
SET tMunis=UPPER(tM unis);
"HousingTow ns" is the table name.
"tMunis" is the field name in which the lowercase text is stored in 154 000 rows.
I get the error message "Undefined function 'UPPER' in expression".
No activity results to display
Leave a comment: