I have an inventory form where in one control I have, lets say "ChairsIn" and in another "ChairsOut".
A third control "ChairsAvailable" should give me the total chairs in that particular apartment. Since the amount of the items constantly change I would like to have a query that looks up a particular apartment out of the inventory table and then calculates the availability of each item (i.e. chairs). How can I do that? Maybe I'm thinking in the wrong direction and shouldn't use a form?
Thanks in advance