Uppercase notation in access 2007

[SDS2]

Hello,

I have a table tblPupils in access 2007.
In this table there is a column called "town". All the towns are in
lowercase.
Now, how can I change all town names to uppercase at once? The property
windows maybe?
I don't know.

Can anybody help me out?


Thanks in advance.



Stan

 

[Douglas J. Steele]

Use an Update query:

UPDATE tblPupils
SET town = UCase([town])

 

[Daniel Pineault]

Simply use the UCase function.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[SDS2]

thanks a lot

Use an Update query:

UPDATE tblPupils
SET town = UCase([town])

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

Hello,

I have a table tblPupils in access 2007.
In this table there is a column called "town". All the towns are in
lowercase.
Now, how can I change all town names to uppercase at once? The property
windows maybe?
I don't know.

Can anybody help me out?


Thanks in advance.



Stan