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(*)

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

CMarshall wrote:
> 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(*)
>