Nadya,

One more way:

SELECT ;
SUM(IIF(MeetsCondition1, 1, 0)) AS NumRecordsWhichMeetCondition1, ;
SUM(IIF(MeetsCondition2, 1, 0)) AS NumRecordsWhichMeetCondition2, ;
etc.


I use this a lot to make counts in columns.


>Hi everybody,
>
>Just wondering is there a way to count records, which met the criteria, without using COUNT FOR FilterCondition TO lnFilteredRecords?
>
>Thanks in advance