Report Filter

  • Thread starter Thread starter Nick
  • Start date Start date
N

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?
 
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.
 
Or set up a form to control what gets printed on your reports as well as
sets the criteria for it.
 
Back
Top