Re: Case When help

[Tim O'Neill]

Hi Peter

Thanks for your reply.

I've just checked again though and the code returns the correct results.

At the minute I have THEN 1 ELSE 0 with sums at the top. My question is where would I need to put in the DISTINCT COUNT code ie what should it replace? Also where would I put the field that I'm doing the DISTINCT COUNT on?

Thanks for the link. Which sub page do I need though please?

Tim