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.