calculating a remainder field



Hi. I have two tables merged together by a query. One is an inventory tableand the other an open order table. The issue I am running into is duplicatine fields from the inventory table for every open order. For example:

PN Qty PO PO Qty
ABC 4 1234 1
ABC 4 5678 1

The issue is if I the do a sum or a pivot table afte exportation, the actual qty on hand is multiplied by the number of open POs. Is there a way to show what the remaining qty is? I tried a simple formula but for something like this I would get the remainder as 3 for each occurrence of this part. Any ideas would be great. Thanks


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