K kadara Registered User. Local time Tomorrow, 00:42 Joined Jun 19, 2010 Messages 43 Jun 24, 2010 #1 I have a report (see the attached pic). In this report I would like to put a field with the sum of quantity subtotals for each PartNo (Total Sum of quantities for each PartNo). Please help. Thanks. Attachments Clipboard01.jpg 82.9 KB · Views: 146
I have a report (see the attached pic). In this report I would like to put a field with the sum of quantity subtotals for each PartNo (Total Sum of quantities for each PartNo). Please help. Thanks.
pbaldy Wino Moderator Staff member Local time Today, 14:42 Joined Aug 30, 2003 Messages 36,157 Jun 24, 2010 #2 It looks like the part number is in the group header. In the group footer, put a textbox with a control source of: =Sum(Quantity)
It looks like the part number is in the group header. In the group footer, put a textbox with a control source of: =Sum(Quantity)
K kadara Registered User. Local time Tomorrow, 00:42 Joined Jun 19, 2010 Messages 43 Jun 24, 2010 #3 Thanks. It's working great.
