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

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
You are making Access work too hard. Try
=Abs( Sum( [Papers] >99 ) )

This assumes your text of 990 is a typo.
 
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

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

Back
Top