I have this code in my query to update every first letter in table to upercase, it is working.
Code:
UPDATE Blokkies
SET
blokkies.Word = UCase(Mid(Trim([Word]),1,1)) &
Mid(Trim([Word]),2),
blokkies.home = UCase(Mid(Trim([home]),1,1)) &
Mid(Trim([home]),2);
I have tried to 2 two of them, but it gives me error "Character found after end of SQL statement"
I know it could be this ."Mid(Trim([home]),2);"
Code:
UPDATE Blokkies
SET
blokkies.Word = UCase(Mid(Trim([Word]),1,1)) &
Mid(Trim([Word]),2),
blokkies.home = UCase(Mid(Trim([home]),1,1)) &
Mid(Trim([home]),2);
UPDATE Afkortings
SET
Afkortings.Woord = UCase(Mid(Trim([Woord]),1,1)) &
Mid(Trim([Woord]),2),
Afkortings.Afkorting = UCase(Mid(Trim([Afkorting]),1,1)) &
Mid(Trim([Afkorting]),2);
Is there a way to do more than one update to diffrent tables, as I have a lot of tables to do this every day.