summation query on different fields

[Honestmath]

hey,

i have this table setup something like this

fields:
id
numparticipants
responded

id can occur lots of times and i want to sum numparticipants for each id for responded = positive, responded=negative and responded=false.

can i do this all in the same query?

thnx a bunch - math

 

[swampBoogie]

select id,sum(iif(responded='positive',1,0) as positive,
sum(iif(responded='negative',1,0) as negative ,
sum(iif(responded='false',1,0) as falsies
from t
group by id

 

[Honestmath]

thnx -- works great.

math