View Single Post
  #4  
Old February 17th, 2006, 05:36 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default How do I make all the text in my table upper case?

Thank you, thank you.

"Nicole" wrote:

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?