R: Counting problem...

S

Stephan&Ralph

Try using the IIF function to generate a number that you can sum:

SELECT Sum(IIF([A] = 'YES', 1, 0)) AS YesOnA, Sum(IIF([A] = 'NO', 1, 0)) AS
NoOnA, ...


This isn't mine but it's posted by Jonh Vinson on this newsgroup few days
ago. And it was a great solution.

Bye
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

System Resource Exceeded/Query Too Complex 4
reserved error -3087 0
Count Problem 3
Help with Iif on Report 4
Count Function in Query 0
Setting up the following expression in a query 2
Problems with Forecast Query 1
DISTINCT records when combined with another query. 2

Top