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

P

PJC54

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
 
S

Steve

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to monitor stock quantity 1
database for tanning salon 2
Negative Numbers 5
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I subtract numbers in a column from one table to another? 1
How do I clear a form? 0
Printing Variable Label Quantities from a Merge 8
Suppress printing group footer using Calculated field(s) 1

Top