Query Problem (1 Viewer)

[sondriven]

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

 

[Pat Hartman]

You need to create a totals query.

Select ProductName, Sum(QtyInOut) AS QtyOnHand
From YourTable
Group by ProductName;

 

[sondriven]

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.