I need all my fields to look like this in my report.

PLAN TOTALS ..

Plan ID... AMT 1.... AMT 2.... AMT 3
1001...... 1111...... 2222....... 3333
2001...... 2222....... 3333..... 4444

DESCRIPTION
DES #....... COUNT1...... COUNT 2
444............. 1234.......... 44333
555............. 2222........... 22222

The best mine will look is like this...

DESCRIPTION 2222

PLAN TOTALS
Plan ID..... AMT 1....... AMT 2 ........AMT 3
1001........ 1111.......... 2222.......... 3333
2001......... 2222........ 3333 ..........l4444

DESCRIPTION 3432
PLAN TOTALS
Plan ID......... AMT 1....... AMT 2 ........AMT 3
1001 ............1111 ..........2222......... 3333
2001............ 2222.......... 3333 .........4444

Notice the Description number is in the same group with the plan totals? How
do I get it to look like the first example? I have tried everything in the
report from grouping etc. Please help!

Need a clue about your table structure to help.

"TKM" wrote:

> I need all my fields to look like this in my report.
>
> PLAN TOTALS ..
>
> Plan ID... AMT 1.... AMT 2.... AMT 3
> 1001...... 1111...... 2222....... 3333
> 2001...... 2222....... 3333..... 4444
>
> DESCRIPTION
> DES #....... COUNT1...... COUNT 2
> 444............. 1234.......... 44333
> 555............. 2222........... 22222
>
> The best mine will look is like this...
>
> DESCRIPTION 2222
>
> PLAN TOTALS
> Plan ID..... AMT 1....... AMT 2 ........AMT 3
> 1001........ 1111.......... 2222.......... 3333
> 2001......... 2222........ 3333 ..........l4444
>
> DESCRIPTION 3432
> PLAN TOTALS
> Plan ID......... AMT 1....... AMT 2 ........AMT 3
> 1001 ............1111 ..........2222......... 3333
> 2001............ 2222.......... 3333 .........4444
>
> Notice the Description number is in the same group with the plan totals? How
> do I get it to look like the first example? I have tried everything in the
> report from grouping etc. Please help!