Query Problem

sondriven

Registered User.
Local time
Today, 11:28
Joined
Jun 13, 2002
Messages
158
I have an inventory form, that includes the Product Name, then I have a subform that shows records of when things are taken out of and put back in. Each record in the subform has a new entry to show what date it was entered.

I want to make a query to pull up the Product Name and QUantity On Hand.

My quantity On Hand field is calculated in the subform.

What Ive done so far is create a query. Linked the two tables together by the ID's. (The Product Table and Subform Table)

When I go to run this, I get a huge list of every record and the On Hand Quantity is empty.

What I want is per Part Number the On Hand Quantity. So I can see this in a list.

Any suggestions?

Thanks
 
You need to create a totals query.

Select ProductName, Sum(QtyInOut) AS QtyOnHand
From YourTable
Group by ProductName;
 
Got it to work with DBL's help in a private message. The posts wasnt working at the time. Thanks Pat. Youre post would of pointed me in the same correct direction.

:)
 

Users who are viewing this thread

Back
Top Bottom