 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2006How do I make all the text in my table upper case?
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? 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 > 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? 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> > I've got a table with 9,000 records in 10 fields. I need to convert all > the [quoted text clipped - 3 lines] > drag > the * down and do the whole table--or must I go do field by field? Thank you, thank you. > 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? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.