That's it in the first instance. I will need to do the automatic update later using the loop. But for now if we just crack the manual method.
If I call the column name: colname, the recordset would look like this:
SELECT (table.inventory - colname) AS available_inventory
WHERE available_inventory > 0
Default value: 0