MDB, fields A,B,C are entered D is BminuC want table to update D

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Access I have several fields which occasionally are updated. Fields of
interest are Qty Authorized, Quantity on hand which are updated during
inventory, how do I have a table automatically update Quantity short
(Authorized minus on hand)

Thank you
 
It's incorrect to have a Quantity Short field in your table! You can always
display Quantity Short in a form or report using the equation:
Quantity Short = Qty Authorized - Quantity on hand

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 
Back
Top