Solved

Convert Uppercase to Mixed Case

Posted on 2011-03-24
11
413 Views
Last Modified: 2013-11-05
I have data in a column that is Uppercase.  I want it to be mixed case.  Example:

SMITH - should be Smith
JONES - should be Jones

Is there a query I can run against my data that would convert it all?

table name = tblPeople
table field = txtLastName
0
Comment
Question by:gcgcit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 3
11 Comments
 
LVL 44

Assisted Solution

by:GRayL
GRayL earned 200 total points
ID: 35210015
StrConv("MY STRING",3)  produces My String
0
 
LVL 75
ID: 35210020
Make a BACKUP first, then try this:

UPDATE Table1 SET Table1.YourField = StrConv([YourField],3);


mx
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35210032
UPDATE tblPeople SET txtLastName = StrConv(txtLastName,3);
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 300 total points
ID: 35210035
Specifically

UPDATE tblPeople SET tblPeople.txtLastName= StrConv([txtLastName],3);
0
 

Author Comment

by:gcgcit
ID: 35210150
How can I do this in query builder?

I made it an update query.

Fieldname: txtLastName
Table: tblPeople
Update To: StrConv([txtLastName],3)

But it prompts me with a message box asking for a value of txtLastName when I try to run it.
0
 

Author Comment

by:gcgcit
ID: 35210168
Ignore that last note, it was a typo on my part!  Got it to work thanks guys!
0
 

Author Closing Comment

by:gcgcit
ID: 35210186
Gave slightly more points to DatabaseMX because GrayL's syntax was off for a table - its not " " but [ ] also DatabaseMX suggested making a backup which I'm glad I did because the first time I toasted my data with the " ".  Thanks to both of you for such a quick response! :)
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35210237
Correction - my syntax was correct as long the name did not contain spaces or any 'strange' characters - underlines excepted.
0
 
LVL 75
ID: 35210248
You are welcome.  ALWAYS  ... make a backup first before running Action queries presented here or elsewhere :-)

mx
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35210257
In the StrConv() example, "MY STRING" was a variable - not the name of a field.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 35210268
Thanks, glad to help.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question