Worked beautifully! Thanks so much, Dave!

Dian ~


-----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

---
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/
 

Reply via email to