If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add percentages
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(*) |
#2
|
|||
|
|||
Add percentages
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(*) |
Thread Tools | |
Display Modes | |
|
|