totals on a report in access

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

Guest

I have two tables, on contain the employee non-conformances, and the other
contains the number of units. I created a report which gives me the
percentage accuracy=total non-conformances/total units by employee. I'm
trying to get the percentage accuracy for the whole department, but it won't
give me the right total number of units by department. Every time an employee
has a non-conformance; it will add the number of units to the grand total
number of units, which is wrong. I only need it to add it once. Any ideas?
 
I tried that, but the subreport keeps asking me for the parameters (dates)
several times, and It's not giving me the right info.
 
Are you using parameter prompts for your criteria? If so, kick your
development up a notch by grabbing your subreport record source criteria
from controls on forms.
 
Duane, Thanks for your help.I created the subreport, and it is giving me the
right information, but it is prompting for parameters 10 times. I've never
used controls on forms, but I will look into that.
 
Duane,
Thanks for your advise, but I haven't been able to add controls on forms.
Can you explain how to do that?
Thanks

Christina
 
Back
Top