Information générale
Catégorie:
Gestionnaire de rapports & Rapports
>>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.
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.
Ideas?
Thanks again!
Jeff
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement