Count number of occurances

[Drew Sanderson]

I have a field that tracks status through a calculation that that results in a number of eithe 0, 1, 2, or 3. I need to have a count of the number of records that have a status of 2. This data will be displayed in a custom dialog. Any ideas? Thanks!

[jteich]

Have a look at this!

-jens

count_numbers.zip

[jteich]

It's also possible to get this result with less helping fields and relationships using a summary field.

But this alternative does only give the right numbers for all records when the resultset consists of all records and when the records are sorted properly.

-jens

[Drew Sanderson]

Thank yo very much for the responce. I think it will do just what I want once I wrap my head around it. I really appreciate your help }:|

Drew