I have this query that is a total query. Here are the field in the query: Part = Group
Qty = Sum
What I would to do is have a inventory form that show the parts(group), the Qty(sum) and ordered, I have the form and it shows the parts, and qty but I can't update the ordered field because of the total query used to get the part and qty. Is there another way to group records together and get the sum of them?
Thanks
Qty = Sum
What I would to do is have a inventory form that show the parts(group), the Qty(sum) and ordered, I have the form and it shows the parts, and qty but I can't update the ordered field because of the total query used to get the part and qty. Is there another way to group records together and get the sum of them?
Thanks