double countings

[pascal]

Hi,

I want to make a query with 2 fields. The first field needs to count all the records in my table. The second field, which is a YES/NO field, needs to count only those records with criteria YES. My question is, if this is possible in one query? Or how can this be done?

Thanks already.

 

[Nouba]

this should work

SELECT
  Count(*) AS TotalCount
, Sum(Abs(YesNoField)) AS CountOfYes
FROM YourTable

 

[pascal]

Thanks Norbert, this really works well. This is it. Thanks again for the quick reply and the right solution.