Summary or Sum of Parts Quantity
I'm tring to sum (add up) all the occurrences of a item in table "A", in my inventory database. The inventory table track the quantities of parts
and has a relationship with the parts table that has all of the different parts. These parts are stored at
different locations so I need a report that will tell me how many of said part I have.
This is a demo project to see if we what to move from MS Access to Filemaker so if you would like to see the database let me and I will email it. I don't see away to attach it in this forum.