update Table (1 Viewer)

M

mohamedmatter

Registered User.
Local time
Today, 08:46
Joined
Oct 25, 2015
Messages
112
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
 

Attachments

  • Training Techer.accdb
    592 KB · Views: 38
arnelgp

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:46
Joined
May 7, 2009
Messages
19,230
put this new Query (SQL view):

Update TeacherTraining Set DateOfTraining=#8/22/2019# Where TeacherGroub="C"
 
You must log in or register to reply here.

Similar threads

M
Solved Top values for unique records
Replies
5
Views
354
bob fitz
bob fitz
P
Update query
Replies
12
Views
379
Gasman
Gasman
Z
2 Tables
Replies
2
Views
189
zezo2021
Z
T
Solved Calculations don't work if one of the fields used in calculation is a null
Replies
3
Views
230
Pat Hartman
P
T
Solved get a value from another table based on the range
Replies
3
Views
147
plog
P

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom