UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> query to calculate units on hand    
 
   
yorck
post Jan 29 2006, 05:28 PM
Post #1

New Member
Posts: 18
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
Go to the top of the page
 
+
truittb
post Jan 29 2006, 05:38 PM
Post #2

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
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.
Go to the top of the page
 
+
yorck
post Jan 30 2006, 12:15 AM
Post #3

New Member
Posts: 18
It worked! Thanks Bull..:-)
Go to the top of the page
 
+
truittb
post Jan 30 2006, 07:50 AM
Post #4

Retired Moderator
Posts: 13,544
From: Texas (Is there anywhere else?)
You are welcome.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 04:06 AM