Cool...thanks! I THOUGHT it would be like that cos' I believe that's how I've done it in VBA, just not always sure that my VBA codes will work in a similar manner to VBS.
REALLY appreciate the help! Dian D. Chapman Technical Consultant, Instructor Microsoft MVP & MOS Expert Certified Free MS Tutorials: www.mousetrax.com/techtrax Free Word Tips & Tricks eBook: www.mousetrax.com/books.html Learn VBA the easy way, thru video! www.mousetrax.com/techcourses.html -----Original Message----- From: David Smart [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 12:54 AM To: [EMAIL PROTECTED] Subject: Re: [ASP] Help! Got a little rounding problem! 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 --- Incoming 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 --- 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 <*> 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/
