Depleting inventory in access

[Norma]

I hope that someone will be able to help with this problem. It is
probably an easy fix for mose of you so bear with me...

I have 2 tables for this. One has item # and InventoryAmount. The
other is daily production which has a linked field for the item #. The
UsedAmount and item # are entered in the daily production each day.
The amount entered as UsedAmount needs to delete that amount from the
InventoryAmount so I get a running total of remaining inventory in a
report....

Easy enough?

Please let me know how to go about this...

Thanks!

Norma

[DC Fan]

Have you build a form where the users enter the UsedAmount data? If so,
create code that runs on the AfterUpdate event that subtracts the UsedAmount
from the inventory amount. If you are not familiar with coding in VBA or
building forms, you may want to consider rebuilding your design to record
inventory input events along with inventory output events. That way, you
can always calculate current inventory by adding up the input events and
subtracting the output events.

HTH

When the UsedAmount is entered into the
"Norma" <nj**********@suscom.net> wrote in message
news:20**************************@posting.google.c om...

I hope that someone will be able to help with this problem. It is
probably an easy fix for mose of you so bear with me...

I have 2 tables for this. One has item # and InventoryAmount. The
other is daily production which has a linked field for the item #. The
UsedAmount and item # are entered in the daily production each day.
The amount entered as UsedAmount needs to delete that amount from the
InventoryAmount so I get a running total of remaining inventory in a
report....

Easy enough?

Please let me know how to go about this...

Thanks!

Norma

[Phil Stanton]

Not a good idea. If anyone makes a mistake in deducting the amount, there is
no record of what the amount was before the deduction or the amount
deducted.
Much better to create a table showing additions and deductions and then you
can retrace your steps. Simple to do a sum of these to get the current
balance.

HTH

Phil
"Norma" <nj**********@suscom.net> wrote in message
news:20**************************@posting.google.c om...

I hope that someone will be able to help with this problem. It is
probably an easy fix for mose of you so bear with me...

I have 2 tables for this. One has item # and InventoryAmount. The
other is daily production which has a linked field for the item #. The
UsedAmount and item # are entered in the daily production each day.
The amount entered as UsedAmount needs to delete that amount from the
InventoryAmount so I get a running total of remaining inventory in a
report....

Easy enough?

Please let me know how to go about this...

Thanks!

Norma