Convert Access table of names

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

Guest

I want to merge a table of names/address with Wble ORD documents. However,
the table has name field in all capital letters; I want it converted to
lowercase letters. What do I do?
 
Export a query instead of the table.

In the query, you can type something like this into the Field row:
LCase([NameField])

Or if you want the first letter to remain upper case:
StrConv([NameField], 3)
 
THANK YOU!

Allen Browne said:
Export a query instead of the table.

In the query, you can type something like this into the Field row:
LCase([NameField])

Or if you want the first letter to remain upper case:
StrConv([NameField], 3)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

ohporter said:
I want to merge a table of names/address with Wble ORD documents. However,
the table has name field in all capital letters; I want it converted to
lowercase letters. What do I do?
Click to expand...
Click to expand...
 
Back
Top