Report Filter

[Nick]

I'm creating a report in which I need only specific information for it. Right
now I have a list of countries and the students that applied from those
countries. I want to have a summary breakdown in the report like this:

USA = A
India = B
China = C
All Other Countries = D

My question is how do I create an expression that calculates the Sum of all
the other countries, while leaving out USA, India, and China?

 

[Duane Hookom]

I would create a table of countries and codes. Add this to your report's
record source query so the A, B, C, and D would be included in your report
for whatever need you have.

When you want to change the codes or remove a country from "D", you edit the
data.

 

[Rockn]

Or set up a form to control what gets printed on your reports as well as
sets the criteria for it.