How do I make all the text in my table upper case?

N

Nicole

I've got a table with 9,000 records in 10 fields. I need to convert all the
text to upper case. I've read I that I need to run an update query. It's
easy to start an update query in design view. But what do I type in the
Update To column? And I don't know what to put in the Field colum. Can I drag
the * down and do the whole table--or must I go do field by field?
 
T

tina

first, before you do anything else: BACK UP your database. this is
essential when you're building/testing any action query, so if you mess it
up, you haven't lost/ruined any data.

in the query design view, you need to pull each field into the grid
separately, rather than using *. in the Update To row of each field, enter
the following expression, as

UCase([TableName].[FieldName])

change TableName to the correct name of the table, obviously. in each
column, change FieldName to the name of the field in the top row of the
column.

hth
 
J

Jeff Boyce

Nicole

In addition to tina's response, please consider...

If you are only concerned about appearance (i.e., you want to SEE ALL
UPPERCASE), you don't need to modify the data. You can use a regular select
query and tina's UCase() function to change the appearance only.

Regards

Jeff Boyce
<Office/Access MVP>
 
Top