Counting Number of Min/Max Instances

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have a report that identifies the min and max values in a field over
a given population. I want to include the number of instances of that
value as well. For example, for q1 the min response value was "2",
which occurred 12 times, and the max response value was "5", which
occurred 2 times.

I am using the rpt footer to show the results (so that it doesn't
repeat for each q the number of responses). I have tried:

=Abs(Sum([q1]=Min(IIf([q1]>0,[q1],Null)))) -- "Cannot have aggregate
function..."
=DCount("[q1]","tbl_questions_responses_all","[q1]=Min([q1])") --
#ERROR

And various other permutations of those examples. I suppose I could do
individual counts on the different response values (1 - 5) and then
return the corresponding value count at the footer, but was hoping to
save my fingers some repeptitive typing (5 response values, 21 total
questions).

Advice?

.

Relevant Pages

  • Re: "Support"
    ... world (see Service Pack 3 Installation Problems in the newsgroup). ... "helpful" response I got was to send a service report to Microsoft. ... symptoms to Microsoft one would wonder about whether it ...
    (microsoft.public.windowsupdate)
  • Re: How conditionally skip stuff on a report?
    ... "Steve" wrote in message ... You could have let well enough alone with your first response without criticizing my response. ... "Jeff Boyce" wrote in message ... Just because the comment field is blank does not mean the report should not display other info in the record. ...
    (microsoft.public.access.reports)
  • Re: How conditionally skip stuff on a report?
    ... The fact that you posted it as a response to my post implicitly criticizing ... you've interpreted as an attack on your proposed solution? ... blank does not mean the report should not display other info in the ...
    (microsoft.public.access.reports)
  • Re: How conditionally skip stuff on a report?
    ... How did my response "implicitly criticize" your proposed solution? ... criticizing my suggested solution. ... blank does not mean the report should not display other info in the ...
    (microsoft.public.access.reports)
  • Re: Letter of claim - p2p
    ... should tell them that you *still* await a CPR-compliant expert's report ... articulated, strong response letter. ... it's the end of consumer internet access the way we know it. ... Please PM / email me to dotpixeldot if you're ...
    (uk.legal)