Averages

[ericMorcombe]

Using access asp vb script

Can anyone give me some advice about displaying averages from columns in a database.

[Manuel Socarras]

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

[Manuel Socarras]

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"

[ericMorcombe]

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?

[Manuel Socarras]

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