Full Version: query to calculate units on hand
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
yorck
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
truittb
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.
yorck
It worked! Thanks Bull..:-)
truittb
You are welcome.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.