Total detail section with exceptions

[mikelev]

I have a report based on a query that adds currency for multiple registers. The detail section is grouped by REGISTER asc.

Looks similar to this (X=some value)

Reg# $100 $50 $20 $10 $5 $1
__________________________________
1 $200 $50 $120 $40 $60 $45
2 XX XX XX XX XX XX
3 XXX XX XXX XX X XX
4
5
8
9
10
11
12
P1
P2
P3
P4
P5
Totals $640 $250 $340 XXX XXX XXX


I would like to insert a subtotal before "P*" values and a grand total after the "P*" values.


To look something like:

Reg# $100 $50 $20 $10 $5 $1
__________________________________
1 $200 $50 $120 $40 $60 $45
2 XX XX XX XX XX XX
3 XXX XX XXX XX X XX
4
5
8
9
10
11
12
SubTotals $300 $150 $180 XXX XXX XXX
P1
P2
P3
P4
P5
GrandTotals $600 $250 $340 XXX XXX XXX

Any help is appreciated~!
Cheers,

 

[BoxHead]

Don't know what other data is in the query, but could you add a column like

RegType: iif(left(regNum,1) = "P", "P","N")

Registers 1 thru 12 would have an "N" value and the P1 thru P5 would have "P" in the column.

Add this column to the sorting and grouping window and display a group footer.

Just a thought.

John

Use what you have,
Learn what you can,
Create what you need.