If you are using the report writer there is a neat trick you can do with an immediate if statement.

Add a field to the bottom of your report (in the summary band)
Under calculations, click on SUM
make the expression something like iif(field = value, 1, 0)

what happens is that as the report is run, whenever the condition is true, it sums in a 1, when it is false, it sums in a 0.

>Hello. I have only been working with 2.6 for about 6 weeks so my questions are very much on the beginners level. I am writing a report in which I want to count the number of records in a group given a certain criteria. I know the format is COUNT TO FOR but I am not sure how to implement this in the group header. I have tried calling a separate program with this as part of the code in the header itself, but get an operator/operand mismatch error. How do I simply count and display the number of records in a group in the group header? Then for a certain criteria? Any help would be greatly appreciated for this beginner!!

--Todd Sherman
-Wake Up! Smell the Coffee!