In the attached Report I have given the formula for Count as COUNT([CR NO]). It is coming as 14. I want it to be 11 which is the actual CR NO seen in the Report. How to do it?
In the attached Report I have given the formula for Count as COUNT([CR NO]). It is coming as 14. I want it to be 11 which is the actual CR NO seen in the Report. How to do it?
Probably have to build a query that returns only 11 distinct records then Count on that query.
Here is a trick that might work.
Set a group on CRNO. Put a textbox in group header: Name of tbxCntGrp, ControlSource =1, RunningSum set to OverGroup, can set Visible No.
A textbox in report footer with ControlSource: =[tbxCntGrp].
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks a Lot! The trick worked. RunningSum should be set to OverAll. GOD BLESS YOU!!!Probably have to build a query that returns only 11 distinct records then Count on that query.
Here is a trick that might work.
Set a group on CRNO. Put a textbox in group header: Name of tbxCntGrp, ControlSource =1, RunningSum set to OverGroup, can set Visible No.
A textbox in report footer with ControlSource: =[tbxCntGrp].
Interesting, OverGroup worked in my test.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I did not test with your db, used mine. So still interesting. But glad it's working.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
The dicrepancy may be because I prepared my report through Report Wizard. While preparing the report I had put grouping to CR NO. After reading your advice I again grouped it. Because of this double grouping this discrepancy may have arisen.