Count for a field 1

[dday01]

Hi All,

This is probably simple, though I don't know how to do it. I have a report and I want to add a field in a section footer that gives a count for how many times the value of 'X' shows up. I added a text box to the section footer and put the following formula in the rowsource:
=DCount("submit1","qryImpStatusrpt","[submit1] = 'X'&quot.

The problem is that it gives me a count of the value of X for the whole report in each section, does not give an individual count for each section. Any ideas?

Thanks,

D

 

[GingerR]

yes it gives you the whole count cause that's what your dcount statement is asking for.

you have to add the criteria that will only count the x's for this particular section.
so pick whatever is your heading group and add it to your criteria:


if that field is TEXT (need single quotes):

=DCount("submit1","qryImpStatusrpt","[submit1] = 'X' and HeaderFieldName = '" & [headerfieldname] & "'&quot


if that field is NUMBER (no single quotes):

=DCount("submit1","qryImpStatusrpt","[submit1] = 'X' and HeaderFieldName = " & [headerfieldname])

 

[dday01]

GingerR,

Thanks, that did the trick! Much appreciated.

D