Add percentages

[CMarshall]

I have a report that counts the number of technicians at different locations
and then counts the number of techs that have attended training at our
headquarters (there are 20 different schools). How can is add a percentage
for each school that gives me the percentage of techs who have the training.

Example: =Sum(Abs([Quantum] Like "??????")) divided by =Count(*)

 

[John Spencer]

The easy way would be to build a report that gave you the data for the sums.
Since we have no clue as to the data structure it is very difficult to give
you more specific advice on what the underlying query would look like.

More complex and tedious would be to build individual controls with something
like the following.
=Sum(Abs([Quantum] Like '??????' AND School='Yard One')) /Count(*)
You would have to build the formula for each combination of course and location.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County