![](/forum/profile/get-photo.asp?memberid=30&type=profile&rnd=592) Extreme Veteran
Beiträge: 565
![500](http://donkarl.com/forum/images/decorations/multiple/500.gif) ![25](http://donkarl.com/forum/images/decorations/multiple/25.gif) ![25](http://donkarl.com/forum/images/decorations/multiple/25.gif)
| Hallo,
albe - 30.11.17 17:09
Sub Test()
UPDATE T_Test SET T_Test.T1_KDNR = UCase T1_KDNR
End Sub
Wenn du das in VBA machen willst:
Sub Test()
Dim strSQL As String
Dim Db As DAO.Database
Set Db = CurrentDb
strSQL = "UPDATE T_Test SET T_Test.T1_KDNR = UCase(T1_KDNR)"
Db.Execute strSQL, dbFailOnError
Set Db = Nothing
End Sub
Wenn du es direkt im Abfrage-Editor machen kannst/willst:
UPDATE T_Test SET T1_KDNR = UCase(T1_KDNR);
----- Gruss - Peter |