R rynorem Registered User. Local time Today, 15:24 Joined Jan 9, 2006 Messages 27 Jul 25, 2006 #1 I have two columns, one is number needed and the other is number stocked. How can I get the number stocked column to subrtract from the number needed column. I need to have it done in query. Those are also the title of the columns. Thanks.
I have two columns, one is number needed and the other is number stocked. How can I get the number stocked column to subrtract from the number needed column. I need to have it done in query. Those are also the title of the columns. Thanks.
L Len Boorman Back in gainfull employme Local time Today, 20:24 Joined Mar 23, 2000 Messages 1,927 Jul 25, 2006 #2 How about select query to get Number Stocked and Number Needed. Then a derived value Balance:[Number Stocked ] - [Number Needed] Len
How about select query to get Number Stocked and Number Needed. Then a derived value Balance:[Number Stocked ] - [Number Needed] Len