Subtracting a column from a column

rynorem

Registered User.
Local time
Today, 15:24
Joined
Jan 9, 2006
Messages
27
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.
 
How about select query to get Number Stocked and Number Needed. Then a derived value

Balance:[Number Stocked ] - [Number Needed]

Len
 

Users who are viewing this thread

Back
Top Bottom