Qry Calculation

[Mr. Hero]

I have 2 tables that contains 2 fields each (ID, and StartNumber) and (ID, SubtractNum). I have tried creating a qry to clone the StartNumber field then the subtratnum is subtracted from the StartNumber an entry is made that links with the correct ID; next, the qry updates the calculated balance into a new table (NewNumbers). Although I have tried, I failed. Please help, I am not sure where I made my mistake. Thanks in advance.

 

[Mr Smin]

I think the following would work
In a query, join the tables on ID
select startnumber and subtractnumber and have a 3rd column as an expression
calc_result:[startnumber]-[subtractnumber]

If you change this to a Make Table Query you would get a new table instead of a query result set but are you sure you want to store these calculated results for long enough to need them in a table?

 

[Mr. Hero]

Mr Smin,
I tried your suggestion. Works, but there is more to it then just that part. I am sorry if this sounds a little confusing. the New table will keep track of the subtraction. So when the qry processes the information, there is record kept for every single subtraction. I hope this make sense, becase this is what I am hoping to be able to achieve this.