Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 440
  • Last Modified:

Convert Uppercase to Mixed Case

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
gcgcit
Asked:
gcgcit
  • 5
  • 3
  • 3
2 Solutions
 
GRayLCommented:
StrConv("MY STRING",3)  produces My String
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Make a BACKUP first, then try this:

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


mx
0
 
GRayLCommented:
UPDATE tblPeople SET txtLastName = StrConv(txtLastName,3);
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Specifically

UPDATE tblPeople SET tblPeople.txtLastName= StrConv([txtLastName],3);
0
 
gcgcitAuthor Commented:
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
 
gcgcitAuthor Commented:
Ignore that last note, it was a typo on my part!  Got it to work thanks guys!
0
 
gcgcitAuthor Commented:
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
 
GRayLCommented:
Correction - my syntax was correct as long the name did not contain spaces or any 'strange' characters - underlines excepted.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You are welcome.  ALWAYS  ... make a backup first before running Action queries presented here or elsewhere :-)

mx
0
 
GRayLCommented:
In the StrConv() example, "MY STRING" was a variable - not the name of a field.
0
 
GRayLCommented:
Thanks, glad to help.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 5
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now