Is this possible: report excluding, then summarizing group of records

[MikeBronner]

Hi guys,

I'm faced with a unique problem: I need to exclude a group of records from a summary report, and then at the bottom of the report list the excluded group and summarize it, and then make a grand total of both parts.

Is this in any way possible? Here's an example:

AAAAAAAAAA 1111111111
BBBBBBBBBB 2222222222
CCCCCCCCCC 3333333333
============================
Sum Group A: 6666666666

DDDDDDDDDD 1111111111
EEEEEEEEEE 2222222222
============================
Sum Excluded: 3333333333

Grand Total: 9999999999

Thanks for all your help! ;-) Take Care,
Mike

 

[KenReay]

Hi

Make a Main report.

Put two sub reports on it.

The first SubReport based on a query excluding the records you want to exclude.

The second SubReport based on a query of only the records excluded above

Regards
Ken Reay
Freelance Developer
kenneth.reay@talk21.com