Setting up a form

[eramirez]

Hi

I have an access table that I imported from excel. It basically has PIN# and 5 fields (numeric) that represent requested items. as I get items in I will ship specific items to the people that requested them. I want to set up a field on a form or wherever that will subtract what I sent from what was requested initially. However, people may get their items in multiple shipments so each person will have multiple orders and may it may be for the same item. I want to have a field that has a running balance of what items remain to be shipped per person.

Should I create another shipped table and insert that as a subform?

Does this make sense?

Thanks
Enrique Ramirez

 

[neileg]

You should store the multiple shipments as mutiple records. You can then sum them and subtract from the number requested. You don't store this balance, you calculate it when you need it.