grouping in summary report

  • Thread starter Thread starter BB
  • Start date Start date

BB

Registered User.
Local time
Today, 02:28
Joined
Aug 31, 2001
Messages
30
I have a summary report that lists accounts with total charges. (These charges are calculated from several subreports of the different types of charges.) In the account footer, I calculate the total for each account.
I really need to group the negative totals from the positives. Can I do this and how?

Thanks,
new to Access
 
Add a calculated column to the query so the report can use it for grouping.

Select IIf(ChargeAme < 0, "Neg","Pos") As RangeGroup,....
 

Users who are viewing this thread

Back
Top Bottom