Full Version: Calculating Summary Information In Reports
jmill
Hello,

I am creating a report with the following information: there are 400 studies, 11 study types, and up to 25 strategies that each study can include. For each strategy, I need to know 1) how many studies use that particular strategy and 2) what the percentage breakdown is of study types. I was able to create a report that provides the percentage of study type/strategy for all studies but the calculation is as a percentage of all studies rather than just within a specific strategy. I used Report Wizard and this is the calculation that is showing: =Count([Study Design])/[AccessTotalsStudy Design].

Any guidance is appreciated, thank you!
Jeff B.
If you are saying that you want a "per strategy" calculation, you'll need to tell Access to "group by" strategy.

That way, each strategy will have its own section, and the calculation can be "per section" (i.e., per strategy).
jmill
Jeff,

Thank you for your response. I have the report grouped by Strategy and then by Study Design with Study Design totaled. This is still only giving me a calculation for all studies rather than by section. I've been working on this for awhile, and I feel like I must be missing something that is quite obvious...
jmill
This is the calculation in the Study Design footer: =Count([Study Design])/[AccessTotalsStudy Design]/[AccessTotalsStudy Design]

and this is the calculation in the Strategy footer: =Count(*)/[AccessTotalsStudy Design]

The number I want is this: Count([Study Design])/[AccessTotalsStudy Design]/[AccessTotalsStudy Design] divided by Count(*)/[AccessTotalsStudy Design]

but I'm having trouble communicating this to Access...
jmill
I figured it out - =(Count([Study Design])/[AccessTotalsStudy Design])/[AccessTotalsPercentStudy Design]