Steven,
>I think my first sql ststement is where I have went wrong. I have a table with a cono field. Many records can have the same cono. I need a count of distinct cono's that have the archivef field set to '0'.
>
>What I think my current sql is giving is the total number of records with the same cono.
>
>SELECT Count(*) As rCount, cono FROM webprddt6.tsotagtbl Where archivef = '0' Group By cono
So, you can to try this:
Select count(*);
From (SELECT Count(*) As rCount, cono FROM webprddt6.tsotagtbl;
Where archivef = '0' Group By cono;
) myAlias
With this you will have the number of cono that has archivef field set to 0.
I hope this help.
Erick
Força Sempre!
Strength Always!