Filter and Calculate in a Form and DAP

[Guest]

OK... No idea where to post this or how to begin, so I'm going to throw a
bunch of info up here and see if anyone can help! )

I have a database table with 3000+ records. The records are stat
information for characters in a MUD. The columns in the table are as follows:

Date, Race, Homeland, Class, Gender, STR, INT, WIL, DEX, CON.

I want to create a form and a DAP I can publish to the web to give other
access to the information. I want to be able to Combo boxes or another
method if a better one exists to allow the following:

Select a date range (from 2 choices: all records and records from the last
year), select a race (there are 3), select a class and a gender. After
clicking a submit button or something, the database would display the
Average, Min and Max of each stat (STR, INT, WIL, DEX, CON) for each homeland.

If possible, I'd also like to set it up to calculate the percentage of each
value. For example, count the number of 9's for STR, divide it by the total
number of records for which there is a STR value and display it as a
percentage. So the display would look something like this:

STR INT WIL DEX CON
Avg: 13.3 14.5 15.2 12.3 11.2
Min: 9 10 10 9 9
Max: 18 19 19 19 18
9: 3.1% 2.1% 1.9% 2.1% 3.3%

Etc.... a list of basically 9 to 19 and listing percents for each of those.

Thanks!
~ In way over my head!

 

[Sylvain Lafontaine]

The newsgroup about DAP is m.p.access.dataaccess.pages . If you want to
take a look at all previous post:
http://groups-beta.google.com/group/microsoft.public.access.dataaccess.pages

My advice: forget about DAP and go with ASP.NET (or anything else).