Professional Web Applications Themes

calcuate averages: code in asp or db? - ASP Database

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, TS...

  1. #1

    Default calcuate averages: code in asp or db?

    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,
    TS
    T. Guest

  2. #2

    Default Re: calcuate averages: code in asp or db?

    Before we can accurately answer, please see http://www.aspfaq.com/5009 and
    http://www.aspfaq.com/5006.

    Ray at home


    "T. Schultz" <net> wrote in message
    news:google.com... 


    Ray Guest

  3. #3

    Default Re: calcuate averages: code in asp or db?

    T. Schultz wrote: 

    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 Guest

  4. #4

    Default Re: calcuate averages: code in asp or db?

    Ray Costanzo [MVP] wrote: 

    "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
     [/ref]

    --
    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 Guest

  5. #5

    Default Re: calcuate averages: code in asp or db?

    Oops! Sorry!!

    Ray at work

    "Bob Barrows [MVP]" <SPAMcom> wrote in message
    news:u8v$phx.gbl... 
    >
    > "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[/ref]


    Ray Guest

Similar Threads

  1. Averages
    By ericMorcombe in forum Dreamweaver AppDev
    Replies: 4
    Last Post: March 23rd, 10:26 AM
  2. lingo averages..HELP!
    By jen in forum Macromedia Director Lingo
    Replies: 0
    Last Post: November 11th, 11:52 AM
  3. Replies: 1
    Last Post: September 17th, 09:41 PM
  4. Replies: 1
    Last Post: September 17th, 09:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139