Increase values in integer field

[Graham Feeley]

Hi all Masters, I have a integer field containing numbers ranging from 2 to
60.
I am looking to increase these numbers by 40.
Please, how do I attain this ????
Regards
Graham

 

[Allen Browne]

Use an update query:

UPDATE MyTable SET MyField = MyField + 40;