Stock Control System

Diksha1310

Registered User.
Local time
Yesterday, 23:42
Joined
Sep 21, 2011
Messages
12
I'm making a pharmacy stock control system..
I want an updatable query which subtracts the field QuantityInStock from QuantitySold,so that i get QuantityLeft..(It must be calculated automatically).!
Can someone help!:confused:
 
Add this as a new column in the query:

Code:
QuantityLeft: [QuantityInStock] - [QuantitySold]
 
Thanx
You were really helpful!
 

Users who are viewing this thread

Back
Top Bottom