Update Table using Query

[Megan]

Is there a query that could update the first letter of the
whole column in my table to uppercase?

If so what would be the criteria?

 

[Michel Walsh]

Hi,


Make a backup.

Then, try


UPDATE myTable
SET field1 = UCase(Left(field1, 1)) & Mid(field1, 2)



There is no criteria if you want to do that for all the records.



Hoping it may help,
Vanderghast, Access MVP