Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • 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 Access MVP)Database ArchitectCommented:
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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 Access MVP)Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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