Update Table

[Jakeman]

Please help this beginner. I have a table called “Threads” with about 9 columns. I would like to go thru table and perform a math function (using data in two of the columns) and place the results into a 3rd column.
Ist column “Maximum Qty”, 2nd column “Current Qty”, 3rd column “Reorder Qty”.
So would like: (“Reorder Qty” = “Maximum Qty” – “Current Qty’).
Guys, I’ve spent about 2 days watching on-line videos, tutorials, and whatever I can find, but nothing seems to help or work.
Need help PLEASE!!!!

 

[accessfever]

If the original 2 columns are already set at Number format, then you should not use double quotes in your formula. You should use the formula like this:

Newcolumn3 = [oldcolumn1] - [oldcolumn2]

 

[Jakeman]

Thanks!! Will try it.