Converting All Caps field to upper and lowercase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a fairly new user and have inherited a database where the Last Name
field was entered as all Uppercase. Can you tell me how to convert the field
where the first letter will remain uppercase and the remaining letter will be
lowercase? I can change the whole field, but not the parts.
 
Rick,

I created the module and followed the directions for the query. On a select
query, I can see the changes in the query, but they do not save into my
table. If I try to use the update query, I cannot put the conLastName:
MixCaseIT([LastName]) in the field name as written in the instructions. I am
told I need a destination field. I tried to put this command on several
other lines in the query, but nothing worked.

The append query worked but created new records with only the last name.
What am I missing?

Thanks.
 
I sent you a whole list of responses. Have no idea which one you selected.

You would build an update query and then update the LastName field. You
would update it to...
MixCaseIT([LastName])


Hope that helps.




Laurasmom said:
Rick,

I created the module and followed the directions for the query. On a select
query, I can see the changes in the query, but they do not save into my
table. If I try to use the update query, I cannot put the conLastName:
MixCaseIT([LastName]) in the field name as written in the instructions. I am
told I need a destination field. I tried to put this command on several
other lines in the query, but nothing worked.

The append query worked but created new records with only the last name.
What am I missing?

Thanks.

Rick B said:
Asked and answered very often...

http://groups-beta.google.com/groups?q=microsoft.public.access+last+name+proper+case


Rick B



the
field will
be
Click to expand...
Click to expand...
 
Back
Top