Group Totals

[matthoward]

In my access datatabase at the moment I have two fields. Transaction Type and Account Number. The account number just lists every ones account number but the Transaction type lists the type of payment for example C for Cheque D for Cash etc etc. So below is an example
Account Number Transaction Type
32564564456 A
32564564456 A
32564564456 D
34289723879 F
34289723879 A

So for the crystal report it will show
32564564456 Transaction Type A = 2 Type B = 1 Type F = 0
34289723879 Transaction Type A = 1 Type B = 0 Type F = 1
and so on.

If someone could help me with the crystal reports side of things I am pulling my hair out and it would be appreciated,

Cheers Matt

 

[Danster]

Try grouping by acct number, then by Trans Type. In the group footer for Trans Type, display the acct number and trans type.
This is the essential bit - you need to do a summary field using COUNT on Trans Type.

That should steer you OK?

cheers

Danster