I should have mentioned that the COUNT(myField) of the SELECT - SQL statement I was using, was not giving me the proper record count.

>>
>>I appreciate any thoughts.
>>
>I would think that a SELECT statement(s) with built in Counts. I believe that Edward Pikman would be able to field this question the best.
>
>SELECT COUNT() etc.