Part of one of my access report look like this: ( only one grouping is shown here, there are parent groups of three layers above LoanID like grouped by business type of customer, business of customer, Account ID of customer).

LoanID | LoanDate | LoanAmt | RepayID | RepayDate | RepayAmount
1 |01/01/11 |100,000 | 1 |10/01/11 | 10,000
1 |01/01/11 |100,000 | 2 |15/01/11 | 25,000
2 |02/01/11 | 75,000 | 3 |12/01/11 | 35,000
3 |05/01/11 |125,000
---------------------------------------------------------------------------
4 |400,000 | | | |70,000

Actually total loan disbused is only Rs. 300,000 , i had hidden (r2,c1) & (r2c2) & (r2c3) by using [HideDuplucate]=Yes in the property of the text field used.

I want the LoanID count to be 3 and LoanAmt sum to be Rs. 300,000 lacs. Is there any function to avoid totalling if the value is not visible ? or any function to total the value of hidden fields.

your reply is highly appreciated !!!


Manoj