Summery report

[Jeremy Corson]

I am trying to find the best way to make a report of summery of the
information collected in my database. I need the total number of calls,
percentage of calls, total time, and percent of time for each one of my five
software companies. For example:

Number of calls Percent of total calls Total Time
Percent of time
Vendor’s Name 100 10%
10 hour 5.45%
Second Vendor 200 20%
20 Hours 10.9%

I have played with the summarize button under query but it doesn’t seem to
come out right when you go to summarize more than one vendor in the same
query. Any suggestions?

 

[Duane Hookom]

I would do this in a report where I you can create totals in group sections
and reference them in the detail section. For instance, assuming your
report's recordsource is grouped by Vendor and has CountOfCalls as a field.
-add a text box box to the report footer:
Name: txtCountCallsReport
Control Source: =Sum(CountOfCalls)
-add a text box to the detail section:
Control Source: =CountOfCalls/txtCountCallsReport