Jeff,

I'm sorry I didn't respond earlier, I have been out of the office. This worked great. I had to do some tweaking but it is now giving me...

Jeff,

I've read part 1 and 2 of your articles and also the article on the Tally table. It looks like you hard code the months in your SUM statements....

Thank you Chrissy and Jeff. I appreciate the quick replies. This is good information. Time to get to work.

My boss forgot to tell me he wants to be able to select a date range for this. Any idea how to do this without knowing how many months...

Thanks Chris!

Thanks.

The users are asked a question and their category, the date they answer, and whether they respond with a Yes or No answer is recorded.

create table PublicSurvey (Category varchar(10), DateEntered...