Combining results of table

[jenyfer49507]

I have a table where the end results looks like the below table. I want to now add some of the results together. Such as add the RI and SL (these are the Adds) results together, the CH and SE (these are the changes) results together and the TM (terms) results will be left alone. Not sure how to do this in access.

Add, Change or Term	Sum
CH	13870
RI	793
SE	676
SL	256
TM	1020

[June7]

One way to try:

In a textbox in form or report footer try expressions in the ControlSource, like:
= Sum(IIf([Add, Change or Term] = "RI" Or [Add, Change or Term] = "SL", [Add, Change or Term], 0)

Another way is to construct a field in query with expression and use that constructed field for grouping criteria:
GroupID: IIf([Add, Change or Term] = "RI" Or [Add, Change or Term] = "SL", 1, IIf([Add, Change or Term] = "CH" Or [Add, Change or Term] = "SE", 2, 3))

[jenyfer49507]

That is exactly what I needed.