>I can add a count subtotal to my report for a certain field, but I need a count of the records where the field equals a certain criteria, and then another count of the same field where the field equals another criteria.
>
>Any advice on how I can do this?
>
>Thanks!
>
>Jeff Rusch
>UW-Madison
1. Report from cursor
2. When you create cursor add two fields like:
SELECT field1, field2, .......
IIF(table.field1=nCrit1,1,0) AS CritField1, ;
IIF(table.field1=nCrit2,1,0) AS CritField2, ;
.......
3. Count SUM() for CritField1, CritField2 as any other report subtotals.
Edward Pikman
Independent Consultant