output for queries automating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take the output of one query which is a list of names and run them
all through a series of other queries automatically. I made a form which has
a drop down list that outputs the results of the query as the choices in the
list. I have to select each one individually and push a button which runs a
series of six queries and outputs the relevant info. I want to automate it,
because it takes too much time.

thank you,
Nicholas Cherry
 
Need more information to respond properly. Why are you running 6 queries to
get the result. Please explain more clearly what you are trying to do. One
way would be to hardcode the queries based on the selection made on the form
or just query all the possible selection on an EVENT procedure such as ON
OPEN or ON EXIT or something else that suits your fancy.

Please clarify better what your wanting to automate exactly.

Dwight
 
Hansford-
I tried to be brief in the question just to get an idea thrown out. I have
a query that I run that produces a list of all of my company's technician's
names. The queries I run on each name count how many jobs complete, cancel,
reschedule or hold. then they divide by the total number of jobs the
technician was assigned, to gain a percentage. thank you for responding. If
this isn't enough info I'll be happy to post more if needed.
Thanks again
Nicholas Cherry
 
I am at a different pc right now one that does not give me access to my
normal files but I think if you do a single query with the fields EmpNames,
JobsComplete, Cancel, Reschedule, Hold and Assigned that you can do a count
of each field and then do your calculation in the query itself.... using a
field of your choosing like EmpCompPct: = Sum([CompleteCount])/[Assigned]
then repeat for each field you want a pct on.

You may have to run two querries to get the Total only of each field by
names but that easier than 6 I will test this later.

I am going to presume that the complete, hold, reschedule, cancel fields are
all in the same table right....

I will test and get back to you if this does not help you out......

Basicall your looking for the following results

Name Complete Cancel Reschedule Hold
Dwight Cornett 40% 10% 20% 30%

There is also a automatic feature in access reports that will show this.
 
Back
Top