Print Page | Close Window

Displaying summary from a database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=152
Printed Date: 28 March 2026 at 10:23pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Displaying summary from a database
Posted By: Sparklebug
Subject: Displaying summary from a database
Date Posted: 14 February 2003 at 3:15am

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!



-------------
bug x



Replies:
Posted By: Bunce
Date Posted: 15 February 2003 at 5:10pm

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



-------------
There have been many, many posts made throughout the world...
This was one of them.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net