changing case from table to query results

[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

 

[Wayne Morgan]

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], "<")

 

[Wayne Morgan]

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.

 

[John Vinson]

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

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.