> >>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.
> >>
> >
> >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.
>
> Thanks Edward! That works perfectly, but I found I also need a count of
> records that don't match either criteria. So I tried:
> IIF(ALLTRIM(famsingl)<>"F" OR ALLTRIM(famsingl)<>"S",1,0) AS fblank but
> this is always returning 1, and I tried
> IIF(ALLTRIM(famsingl)<>"F",IIF(ALLTRIM(famsingl)<>"S",1,0),0) AS fblank but
> this always returns 0.
Rather than SELECT the iif() expressions, include them as the
expressions in the report and get the sum on them there. This may
eliminate the need for the extra SELECT.
/Paul