Hi all.
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

You should record the chairs in as a positive number and the chairsout as a negative number and use a totals query to sum that one field to calculate the chairs avaliable.

It worked! Thanks Bull..:-)

You are welcome.