Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

interesting problem

Status
Not open for further replies.

patty1

Programmer
Apr 17, 2002
105
US
Does anyone know why a running sub-total changes if I hide the details section? If I show the details, the total is correct but if I supress or hide, it changes.

Any help appreciated.

Thx.
 
correction - not a running total just a subtotal based on a group.

sorry about that.
 
I have found that if I have "Select Distinct Records" selected, and fields within the Details section make a record distinct, that hiding that section may change the total number of records retrieved from the query.

You may want to either unselect the option for distinct records, or add criteria/fields to the report so that all the records you want to see are included in the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top