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

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
 
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 do i set an Access table field equal to a VB variable? 5
Table Design 5
Populating multiple fields in a table (from a combo box) automatic 3
Running tally comparing two columns in unsorted list 7
Compare two datasheets and create a new one with modified and newinformation - Excel 1
Update query to update new qty and cost 1
Data from 2 sheets to create a new sheet with user input? 1
Re: Ctrl-a, F9 doesn't work to update all fields including TOC 4

Top