Inventory calculation

[lj1064]

Trying to do an inventory calculation in my customer header. Right now I have this in the customer header - =Count(IIf([Request]="Install",1)) one for installs and one for removals and =[Remove]-[Install]. This is reading each customers totals. I am having trouble figuring out how to incorporate a unique starting number for each customer to come up with an "on hand" total. example have 10 panels install 5, remove 4, have 9 on hand. Been at a bypass for a while.



Thanks

lj

[aytee111]

Create a query and get it working, you can then transfer either the values or the calculation to the form. This is surely not tied to the customer, it would be tied to an order? Where are the quantities being stored in the database? Install, remove, on hand.

[Micron]

=[Remove]-[Install]

These are field names or control names? If field, they should be the names of the controls that contain the calculations (which cannot be in the detail section). If the fields and controls have the same names, it might be ambiguous to Access. Probably should be along the lines of =txtRemove - txtInstall in the header or footer.