Prev: Access Database Error
Next: Autonumbering Query
From: SDS2 on 10 May 2010 14:58
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

From: Douglas J. Steele on 10 May 2010 15:00
Use an Update query:

UPDATE tblPupils
SET town = UCase([town])

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

"SDS2" <nomailtoSDS(a)collegewaregemdeletethis.com> wrote in message
news:%239f2MLH8KHA.1760(a)TK2MSFTNGP04.phx.gbl...
> 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


From: Daniel Pineault on 10 May 2010 15:36
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" wrote:

> 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
>
> .
>
From: SDS2 on 11 May 2010 15:28
thanks a lot

"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> schreef in bericht
news:%23LirdMH8KHA.1760(a)TK2MSFTNGP04.phx.gbl...
> Use an Update query:
>
> UPDATE tblPupils
> SET town = UCase([town])
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "SDS2" <nomailtoSDS(a)collegewaregemdeletethis.com> wrote in message
> news:%239f2MLH8KHA.1760(a)TK2MSFTNGP04.phx.gbl...
>> 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
>
>

 | 
Pages: 1
Prev: Access Database Error
Next: Autonumbering Query