MS Access 97 subtotal for a group - TechRepublic
General discussion
March 19, 2001 at 07:21 AM
steves815

MS Access 97 subtotal for a group

by steves815 . Updated 25 years, 3 months ago

A report has been designed that contains 13 columns. Each row represents monthly sales for a product line. Each group of rows represents sale for a salesman. ie grouped by salesman and product. Each column represents a month with column 13 being a total. The formula is [col1] + [col2] + …[col12]. The textbox control is visible and this field prints correctly. There is a group footer for each salesman and each product line. There is a report footer. In the detail section there is an invisible textbox with the same formula as the one above except that the running sum property is set to “Over All”. (call this text106). In the report footer is a text box set to “=text106” to print the report total. This prints correctly. In the detail section there is another invisible text box with the same formula as above except that the running sum property is set to “Over Group”. (Call this text107). In the group footer for the saleman group there is a visible text box set to “=text107”. I want this to print a total for each set of records for each salesman, but the value of text107 is always the value of the last printed row. ie the group total I am getting is for the product group (the “inner” group) as opposed to the salesman group. How canI make this work the way I want it to?

This discussion is locked

All Comments