Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Help with a QuerY
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

e3stone
Average Member

USA
885 Posts

Posted - 29 April 2001 :  16:01:37  Show Profile  Send e3stone an AOL message
I have a field in one of my databases which is "YearsExperience" I want to get the average of all the returned records from that fieid. How do I do that? I can't get the syntax correct when using the SQL aggregate functions in ASP

<-- Eric -->


http://insidewaco.com/forum

Aznknight
Senior Member

USA
1373 Posts

Posted - 29 April 2001 :  16:16:30  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
try this:


strSQL = "SELECT AVG(YearsExperience) as AverageExp FROM TableNameHere"
rs.open strSql, my_conn

intAvgExp = rs("AverageExp")



- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource

Edited by - aznknight on 29 April 2001 16:16:52
Go to Top of Page

e3stone
Average Member

USA
885 Posts

Posted - 29 April 2001 :  16:30:24  Show Profile  Send e3stone an AOL message
That'll work. Thanks Alan

<-- Eric -->


http://insidewaco.com/forum
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000 Version 3.4.07