Database = MS Access
I want to update a field based on a second field. In the updated field the first character of the string must be changed to UpperCase.
Field1= my tekst
Field2= My tekst
Update Mytabel set Field2 = UppercaseFirstChar(Field1)
Can anybody give me an example on how to do this?