Count number of records in a report group where field is >99

J

Joe W

I've been trying to use the DCount function to count the number of records in
a report group where the specified field is >990, with the following control
source placed into the group footer:

=DCount("[School]","Sheet1","[Papers] >99")

Problem is it give the total records of the entire table...not just within
the group.

Anyone have an idea how to fix this?

Thank you!
 
D

Duane Hookom

You are making Access work too hard. Try
=Abs( Sum( [Papers] >99 ) )

This assumes your text of 990 is a typo.
 
J

Joe W

Sweet... works beautifully. Thanks!

Duane Hookom said:
You are making Access work too hard. Try
=Abs( Sum( [Papers] >99 ) )

This assumes your text of 990 is a typo.

--
Duane Hookom
MS Access MVP
--

Joe W said:
I've been trying to use the DCount function to count the number of records
in
a report group where the specified field is >990, with the following
control
source placed into the group footer:

=DCount("[School]","Sheet1","[Papers] >99")

Problem is it give the total records of the entire table...not just within
the group.

Anyone have an idea how to fix this?

Thank you!
Click to expand...
Click to expand...
 
Top