terribly difficult question

[Guest]

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???

 

[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???

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