terribly difficult question

C

cherrynich

I have a form that runs a set of queries, using specific information I enter
on the form. It calculates a percentage, when I enter a technicians name.
Every week I must get a percentage for each of my 240 techs, i have to enter
a tech's name then get it's percentage, write it down, then enter the next
name get it's percentage write it down. By the time you do that for 240 techs
you've wasted an hour. Is there a way that I can make a query or a report
that will calculate the percentages for each technician automatically???
 
J

John Vinson

I have a form that runs a set of queries, using specific information I enter
on the form. It calculates a percentage, when I enter a technicians name.
Every week I must get a percentage for each of my 240 techs, i have to enter
a tech's name then get it's percentage, write it down, then enter the next
name get it's percentage write it down. By the time you do that for 240 techs
you've wasted an hour. Is there a way that I can make a query or a report
that will calculate the percentages for each technician automatically???
Click to expand...

Certainly, unless you must enter information other than the identity
of the technician on each form. This kind of query is what Access is
designed to do!

Without knowing how the queries work I cannot say just what this query
might be, but I'm certain that the 240 percentages can be calculated
in a single query (perhaps one which uses other queries). You'ld get a
240-line recordset which could be printed as a Report, costing you
printer toner but saving you from writer's cramp (and possibly from
transcription errors!)

Could you (briefly) explain these queries?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
C

cherrynich

There are a series of select queries I run to figure a percentage, with this
criteria:
beginning date
ending date
status
technician name
I have to establish the beginning and ending dates, but then everything else
is always the same, the status is C, and I just enter each techs name one at
a time.
my queries do this;
1. select the rows that are statused C within the beginning and ending dates
with that technician, count them
2. count how many total rows lie between those dates with that technician
3. count how many rows are statused "nlos" or "ntr" with that technician
4. calculate status count(1.)/(total count(2.)-nlos/ntr count(3.))*100
and that gives us each technicians percentage for the week.

I hope I was specific enough for you on the queries if not let me know
 
Top