Groups | Blog | Home
all groups > inetserver asp db > august 2004 >

inetserver asp db : calcuate averages: code in asp or db?



schultz NO[at]SPAM a2z4u.net
8/31/2004 4:54:21 PM
Hi,
I am new to asp and am building a gradebook app. in asp vbscript using
dreamweaver mx 2004 and access 2000. I need to know, in order to
calculate student averages, do I code an asp page or do I code
something in the db. I also need to be able to calculate separate
category averages (ie: Homework 50%, Quizzes 10%, and Tests 40%), and
be able to drop low scores from select categories.
Thanks,
Ray Costanzo [MVP]
8/31/2004 8:55:30 PM
Before we can accurately answer, please see http://www.aspfaq.com/5009 and
http://www.aspfaq.com/5006.

Ray at home


[quoted text, click to view]

Bob Barrows [MVP]
9/1/2004 7:08:42 AM
[quoted text, click to view]

This should be done using grouping queries. Using looping code in vbscript
will be very inefficient. Here is a link to get you started:
http://www.w3schools.com/sql/sql_groupby.asp

The Access Query Builder makes it easy to build grouping queries. Check out
Access online help. Google for posts by me containing the words "saved
parameter query"

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Bob Barrows [MVP]
9/1/2004 7:22:28 AM
[quoted text, click to view]

"using dreamweaver mx 2004 and access 2000"

;-)

I've missed this myself in the past: even when it is glaringly stated in the
subject line - very embarassing.

Bob

[quoted text, click to view]

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Ray Costanzo [MVP]
9/1/2004 12:41:28 PM
Oops! Sorry!!

Ray at work

[quoted text, click to view]

AddThis Social Bookmark Button