Thanks. Now THAT I've done in VBA a lot with invoicing. But since the SQL worked off the query...I'll stick with that. Thanks for the added info.
Dian ~ -----Original Message----- From: Mark E [mailto:[EMAIL PROTECTED] Sent: Sunday, May 09, 2004 7:17 AM To: [EMAIL PROTECTED] Subject: Re: [ASP] Help! Got a little rounding problem! Dian, If you are looking to reduce the length of the number, this will work: FormatNumber(averageRS("AvRating"), 2) Using your example below of 4.8571428571428571428571428571, the output would be 4.86. Mark Dian Chapman <[EMAIL PROTECTED]> wrote: 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! 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 --------------------------------- Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs [Non-text portions of this message have been removed] --------------------------------------------------------------------- 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 ------------------------ Yahoo! Groups Sponsor ---------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM ---------------------------------------------------------------------~-> --------------------------------------------------------------------- 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/
