changing case from table to query results

  • Thread starter Thread starter mikeL
  • Start date Start date
M

mikeL

how do I change the capitalized names in a table so that
the results of a query are all lower case? this would be
in Access 02
thanks
mike
 
To make the result in a query, create the field as a calculated field and
use the Format command.

In the Field row of the design grid:
NewFieldName: Format([FieldName], "<")
 
Another option, place the field in the query as you usually would then right
click the field. Choose Properties from the popup menu and place < in the
Format option.
 
how do I change the capitalized names in a table so that
the results of a query are all lower case? this would be
in Access 02
thanks
mike
Click to expand...

Create an Update query based on the table; update the field to

LCase([fieldname])

to do it permanently. If you want to leave the table data alone, you
can simply use

NewName: LCase([fieldname])

as a calculated field.
 
Back
Top