counting in reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report has a sub client group, a client group and a report group. I need
to know the total displayed records by group, by client group and the report
as a whole. Since the displayed records do not show all the detail from the
table, (multiple reocrds in the table only one is displayed) I have an
unbound field that counts the displayed records. I have succesfully been able
to count the displaed records for each sub group but can not seem to get a
good count for the client group. (Total for the previous sub client groups)
 
If I understand correctly, you can use =Count(*) to count the number of
detail records in any group. Are you trying to count groups or something
else?
 
Sample of report:

Client ABC corp
Company 1
Acct # reference number #of trans
1 984654654 9
2 1684984651 7
(Group footer for acct)
2 total accounts 16 transactions

Company 2
Acct # reference number #of trans
1 1654654654 5
2 9989898912 2
3 2565646546 20
(Group Footer for acct)
3 total accounts 27 transactions
(Group Footer for client)
*5 total accounts for ABC 43 transactions

Client Unity States
Company 1
Acct # reference number #of trans
1 984654654 8
2 1684984651 7
(Group Footer for acct)
2 total accounts 15 transactions

Company 2
Acct # reference number #of trans
1 1654654654 5
2 9989898912 1
(Group Footer for acct)
2total accounts 6 transactions
(Group footer for client)
*4 total accounts for ABC 21 transactions
(Report footer)
9 total accounts 64 transations

Acct # is an unbound control that sequentially numbers each line within each
acct group (Compnay 1, Company 2). I have the running sum set to “over groupâ€
for the acct footer and “over all†for the report footer. The Group Footer
for client (*) is what I am not able to calculate.
 
IF for companies you have used Count function for Client
you have to use Sum function.

But before this use a query when you group by Client,
company, Acct#, Count@ofTrans

if Count@ofTrans is a field (7,9)

Total = sum(Count@ofTrans)=16
Hope you undestand it.

Thanks,
Marsela


For Client grou
 
There are a couple methods that might work. The first is to create a totals
query or queries that calculate the exact values you want. Add the final
"totals query" to your report's record source and join the appropriate
fields. You can then add the value/column into your report's record source.

The other method uses a text box in a group header or footer with a running
sum. If the text box name is txtMyRunSum, you can get the final running sum
value by placing a text box in the "container group" footer with a control
source of:
=txtMyRunSum
 
Back
Top