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

G

Guest

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.
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count In Group Footer 1
A03 - count in report footer gives me #Error? 0
Dcount the values 0
Count or sum unique records in a report's group footer in Access 2 2
Counting Unique Values within a Group 2
Count/Dcount and Group Header 4
How to count records using count(*) in a chart report 3
Count records, but not dupes 15

Top