Count records in detail footer section

[schumarg]

Hi,

Trying to count and show the records in a detail footer section that have a dollar value of $0.00 in the detail section. Report is grouped by a joined field, but can't see where that should matter if I'm only trying to count records. Have tried the following but it returns the count of all records within the detail section. Don't understand why it's not working. Any help or hints would be appreciated.

Example:

Name Order Date Amount
R. Smith 100012 01/01/01 $123.98
B. Smith 100001 01/02/01 $133.33
G. Smith 100233 03/03/01 $ 0.00

Count should = 0, but is returning a count = 3

=Count([GKSTI]=0)

Thanks,
Bob

ps: This post is a followup on a previous DCount post.

 

[nickjar2]

try:

=DCount("[fieldName]","tableName","[fieldName] = 0.00&quot

Nick

 

[schumarg]

Hi,

Tried that one, however it returns a count of all records with an amount of $0.00 for the entire report. I used this for the cover sheet, but would like to show the count within the footer section for each group.

Thanks,
Bob

 

[JoeMiller]

=DCount("[fieldName]","tableName","[MyGroupFieldName]=[MyGroupFieldControlName] AND [fieldName] = 0.00&quot Joe Miller
joe.miller@flotech.net

 

[schumarg]

Thank you!!

Working great now.

Bob

s-)