Greater than etc count help please

[Guest]

I am trying to show in an Access 2000 report how many times a field is above
a given number: I.E. how many scores in field ‘Test1' were above 90. Being
the greedy sort I am, elsewhere in the same report I’d like to show how many
of the same field entries were below a given number.
Also, is it possible to show the highest and lowest score in that field
(again, ‘Test1')
BTW, I am definitely . . . Database Challenged. . . thanks in advance for
any help!

 

[John Spencer]

In the report footer (not the page footer), add controls

Set the control's source to
=Abs(Sum(Test1>=90))

Another Control to
=Abs(Sum(Test1<90))

Another control to
=Max(Test1)

and finally
=Min(Test1)

If you have many different field that you want to do this for, then you
might want to consider using a query as the source for a report or
sub-report

 

[Guest]

Thanks so much, everything worked great!