update Table

[mohamedmatter]

i attach simple data base
i want up date filed DateOfTraning in Table equal 22/8/2019 by condition TeacherGroub filed in Table equal C

 

[arnelgp]

put this new Query (SQL view):

Update TeacherTraining Set DateOfTraining=#8/22/2019# Where TeacherGroub="C"