>If I have a table that has 20 records in it, and the first 10 store the number 1 and the second 10 store the number 2 in it. Is there any way to use the SQL Select statement to count the number of occurences of 10 and 20 in one statemnet? Or do I have to use a calculate cnt() statement twice, once for 10 and once for 20.
>
>Thanks,
>Matt
You can use this :
select sum(iif(number = 1,1,0)) AS num1,SUM(IIF(number=2,1,0)) AS num2 FROM AA into cursor result
cursor result will have 1 row and 2 columns. Column 1 is number of records with
1 and column 2 is number of records with 2

ALEX