totals on a report in access

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

 

[Duane Hookom]

Maybe put non-conformances in a subreport. The n-c records will not affect
sums.

 

[Guest]

I tried that, but the subreport keeps asking me for the parameters (dates)
several times, and It's not giving me the right info.

 

[Duane Hookom]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Duane Hookom]

There are a number of good tutorials on Martin Green's site
http://www.fontstuff.com/access/index.htm. Make sure you look at this one
http://www.fontstuff.com/access/acctut08.htm.

 

[Guest]

Thanks a lot. It worked!!

There are a number of good tutorials on Martin Green's site
http://www.fontstuff.com/access/index.htm. Make sure you look at this one
http://www.fontstuff.com/access/acctut08.htm.