ROUND(AVG(RatingNum),1)
should do the trick (to 1 decimal), or just
ROUND(AVG(RatingNum))
should give you a whole number.
Dave S
----- Original Message -----
From: "Dian Chapman" <[EMAIL PROTECTED]>
To: "Group - ASP" <[EMAIL PROTECTED]>
Sent: Sunday, May 09, 2004 3:20 PM
Subject: [ASP] Help! Got a little rounding problem!
> ROFLMAO! Umm, okay, so I'm not a math person!
>
> You guys gave me the help I needed to realize that I could use AVG to get
an
> average for a bunch of numbers, but...there's a bit of a rounding problem
I
> didn't realize.
>
> Here's the line I use to get the average from a bunch of article rating
> numbers:
>
> averageRS.Open "Select AVG(RatingNum) as AvRating from rating where
> ArticleID = " & Session("varArticleID"), Conn, 1, 3
>
> It seemed to work great...until more folks entered their ratings. Some
> results end up needing a 11" inch page width to display the number!<lol>
>
> Here's a fun example, click the rating button at the bottom of this
article:
> http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=297
>
> Note the number of stars it says this article has received!
>
> 4.8571428571428571428571428571
>
> Umm...anyone know how I can modify the code so we're not going nuts here?
>
> TIA...
>
> Dian ~
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.677 / Virus Database: 439 - Release Date: 5/4/2004
>
>
>
>
>
> ---------------------------------------------------------------------
> Home : http://groups.yahoo.com/group/active-server-pages
> ---------------------------------------------------------------------
> Post : [EMAIL PROTECTED]
> Subscribe : [EMAIL PROTECTED]
> Unsubscribe: [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> Yahoo! Groups Links
>
>
>
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.679 / Virus Database: 441 - Release Date: 7/05/2004
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
