Prev: How to break some SQL into VBA
Next: Difference between numbers
From: CMarshall on 28 Feb 2010 21:21
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(*)

From: John Spencer on 1 Mar 2010 09:01
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(*)
>
 | 
Pages: 1
Prev: How to break some SQL into VBA
Next: Difference between numbers