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

"Nicole" wrote in message
...
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?