View Single Post
  #1  
Old April 16th, 2009, 04:39 AM posted to microsoft.public.access
Sammy[_4_]
external usenet poster
 
Posts: 2
Default Output Date Grouping

I have data in the following columns

The 5 columns of data are as below
A B C D E
Acct Subacct Project DebitAmt CreditAmt

I want to output via a report /or send to Excel data that will get
summarised DebitAmt and CreditAmt by

Account, Subaccount, Project
I was trying to sum of the Totals of the DebitAmt
and the CreditAmt for each Distinct (Acct, Subacct, Project)

So I would have distinct
Acct Sub Project Sum(DebitAmt) Sum(CreditAmt)

I would really apprecaite some guidance on howI can accomplish this as I am
a complete novice at this.

Thanks

Sam