Action Queries: UPDATE
• UPDATE table SET field = value [, field =
value ...] WHERE criteria
• Examples
Update Authors Set Commissions = (Sales * 0.1)
Update Authors Set Address = ‘123 Maple’
Where (AuID = 3121)
Update Authors Set Dead = False, Stupid = True
Where ( (Sales > 100000) and (Commissions =
0) )
[Note use of ( ) in where clause]
Docsity.com
