Okay ... clueless-ish ASP newbie question ...  Someone has built me an ASP survey form which works fine - the results are placed into a very simple Access database. However, he hasn't built me a page to show the results of the survey.  I thought I'd have a go at doing this myself.

In the current survey there are 4 questions with between 2 and 8 multiple choice answers.  The database I'm working with has a single table with fields for the 4 questions into which the answer selected for each question goes.  I can get these results to display on an ASP page but I can't work out how (indeed if!) I can get the page to give a summary of the results rather than list every individual response using this simple database

I have now renamed the inputs for the multiple choice answers so they are just numbers.  Is there some code I could use which would, for example, look at the field for Question1, work out that there are 10 responses which selected input '1', 15 responses that are '2' and 20 for input '3' ... and display the quantities for each as totals?

Or ... am I looking at a database redesign?

Any clues would be much appreciated!

Create query in the Access database which 'GROUPS' the data.

You can then draw summaries straight from the database rather than trying to doit in your ASP page.

Cheers,
Andrew