Professional Web Applications Themes

Averages - Dreamweaver AppDev

Using access asp vb script Can anyone give me some advice about displaying averages from columns in a database....

Sponsored Links
  1. #1

    Default Averages

    Using access asp vb script

    Can anyone give me some advice about displaying averages from columns in a database.
    Sponsored Links
    ericMorcombe Guest

  2. #2

    Default Re: Averages

    "SELECT DEPARTMENT,AVG(SALARY),SUM(SALARY) FROM EMPLOYEES GROUP BY
    DEPARTMENT"
    Manuel Socarras Guest

  3. #3

    Default Re: Averages

    the result will be something like the table in:

    [url]http://projectes.esdi.es/msocarras/sql/group.asp[/url]

    HTH,

    manuel

    Manuel Socarras wrote:
    > "SELECT DEPARTMENT,AVG(SALARY),SUM(SALARY) FROM EMPLOYEES GROUP BY
    > DEPARTMENT"
    Manuel Socarras Guest

  4. #4

    Default Re: Averages

    Thanks Manuel that was most helpful.

    I have lots of columns, all numbered. Is there a way i could create then increment a variable within a loop to display all the averages of each column?
    ericMorcombe Guest

  5. #5

    Default Re: Averages

    check Tom Muck's Horizontal Looper extension
    ([url]http://www.tom-muck.com/extensions/help/HorizontalLooper/[/url]). i've never
    used but may be it can help

    anyway, you could store the recordset in an array:

    rsArray = rs.GetRows()

    and then loop through records and columns with 2 nested IF's. there's a
    detailed example in ASP101.com
    Manuel Socarras Guest

Similar Threads

  1. Site that displays averages of surfers' technical specs?
    By Mike Schmidt in forum Macromedia Dynamic HTML
    Replies: 4
    Last Post: March 4th, 07:35 PM
  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