calculate Qtys

  • Thread starter Thread starter KMZ
  • Start date Start date
K

KMZ

In my parts location DB I have a "Qty O/H", "Qty Used".
I can get a total parts on hand by using the expression
Total Parts On Hand: [Qty O/H]-[Qty Used] BUT how do i get
the "Qty O/H" to change when i enter a qty used?
any help would be greatly appreiated.
 
an update query should work. i assume that you are using a
form and will enter the quantitiy and can trigger the
update query to run somehow.
 
Thanks, I will try it. and yes I am using a form.
-----Original Message-----
an update query should work. i assume that you are using a
form and will enter the quantitiy and can trigger the
update query to run somehow.
-----Original Message-----
In my parts location DB I have a "Qty O/H", "Qty Used".
I can get a total parts on hand by using the expression
Total Parts On Hand: [Qty O/H]-[Qty Used] BUT how do i get
the "Qty O/H" to change when i enter a qty used?
any help would be greatly appreiated.
.
Click to expand...
.
Click to expand...
 
Back
Top