report statistics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nevpoe - 30 Jan 2005 09:35 GMT

I am trying to report some percentages on my report and am unsure how to set
it up. I need to report what percentage was between a specific range, what
was below that range, and what was above that range. I tried a query but you
cant run these all at once. Thanks for the help.

Reply to this Message

John Nurick - 30 Jan 2005 10:27 GMT

You can do it all at once in a query, though it's beyond what can
conveniently be done with the query designer. Here's an example:

SELECT
SUM(IIF([XXX]<400,1,0))*100/Count([XXX]) AS PercentUnder400,
SUM(IIF([XXX]>=400 AND [XXX]<500,1,0))*100/Count([XXX]) AS Percent
400To500,
SUM(IIF([XXX]>=500 ,1,0))*100/Count([XXX]) AS PercentOver500
FROM tblMain;

If you want to display the percentages in textboxes in the report footer
(a typical way of doing it) you could instead use expressions like this:

=DCount("[XXX]","tblMain","[XXX]>=400 AND [XXX]<500") * 1000 /
DCount("*","tblMain")

>I am trying to report some percentages on my report and am unsure how to set
>it up. I need to report what percentage was between a specific range, what
>was below that range, and what was above that range. I tried a query but you
>cant run these all at once. Thanks for the help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

nevpoe - 31 Jan 2005 07:17 GMT

Thanks, I will give it a try.

> You can do it all at once in a query, though it's beyond what can
> conveniently be done with the query designer. Here's an example:
[quoted text clipped - 21 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message