Coverting Upper Case to Lower Case

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

Guest

Do you know of a fairly simple way for a user to export lowercase and
uppercase textual data from an Access database into mixed case data in a Word
document or Excel spreadsheet. For example if someone's name in the database
is all upper case then can it be exported to the first letter as upper and
the remaining text as lower.

Thanks,
 
You can use the strconv function

In a query
Select strconv(FieldName,3) As NewField From TableName
 
Back
Top