count records

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

Guest

I am trying to set up a report that will give me a percentage of employees
who are meeting their goals. I have the report set up to group the data by
employee service level. However, I am having problems counting the records
to show the percentage of reps that meet their goal 90% of the time based on
the differant service level criteria. Can someone please help?
 
Do you have some sort of firm number, or text, that will be a clue as to
whether they hit their goal or not? Or is their goal stored in another
field?

You'll need to have some sort of solid thing that Access can say yes or no
about, count the number of yes's, count the number of total records, then
divide them and format as a percentage.

So to get started, determine how you'll get your yes and no's. Then look at
doing a Count in the Totals row of your query with the criteria set to look
for what triggers the yes.
 
Lynn,

Thanks for your response. I was able to get the answer I needed by view
other questions.
 
Back
Top