Report Help: Summing values in multiple fields

[FJB]

I need some additional help with a report. This database is used by
one individual to keep statistics on weekly meetings. Management has
requested a report from this database on a periodic basis to show what
kind of cases which are being discussed. Below is the structure of the
database:

ID
Date
Time
Manager
Attendees
Case Presented By *
Name of Case
Case Number
Violation Category1 %
Violation Category2 %
Violation Category3 %
Recommendation &
Additional Comments

(1) Is it possible to capture the dates which are put in as part of
parameter for use in the report header?

(2) The list of investigators (Case Presented by) will be hard coded
and I am comfortable in getting the actual counts [=Sum(IIf([Violation
Category1]="Unusual Cash",1,0))]

(3) The Violation categories will also be hard coded. The problem
comes in trying to count/sum the occurrences in all three fields into
one total by category.

(4) The Recommendation category need to allow for many different
values without being hard coded, but allowing all of the values
present to be on the report.

As always, thank you for your help. I will try to better explain
anything that is not understood.

Frank

 

[Duane Hookom]

Is it possible to normalize your table structure before investing any more
time creating reports?

Parameters should be entered into controls on forms rather than entered as
parameters. Either way, you can set a control source to something like:
=Forms!frmDateEntry!txtStart
or
=[Enter Starting Date]

To display counts of recommendations, consider using a totals query as the
record source of a subreport. You should do the same for violation categories.