Running total for only last two groups

[ak747]

Hello,

I need help adding the last two groups together.

Group 1
XX YY $5.00

Group 2
AA BB $4.00
BB CC $3.00

Group 3
CC DD $10.00
AA BB $5.00
EE FF $5.00

Group 4
TT BB $2.00
SK FH $1.00

Total: (Here I would like to add Group 3 and 4 only. So the answer would be $23)

Thanks for your time and help!

 

[NickHa]

What do the groups represent? Are these identified by a field in a table whose records also contains the other details as fields?

You need to give more context in order to get sensible replies!

 

[ak747]

Sorry for not being clear. I quite didn't understand what you are asking but let me explain the structure of my database or the source for my report.

The report's recrod source is set to a query that gets the data from two tables. In the report I have created a group on one of the fields (thats what I mean by group1..group2 and so on).

Just think groups as "Departments" and each department will have various products with name and price. So far I can do a total for each department ( =sum(price) ) and get the sum printed in the group footer. But I would like to forget about all the departments except last two. I would like a text box that gives me the total for the last two departments only.

In other words, how do I remember the sum for the previous department?