Use CEILING
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ryan Everhart Sent: Tuesday, April 05, 2005 2:25 PM To: [email protected] Subject: Easy Rounding TSQL Question The query below returns a value of 4 and I would like to get a value of 5. COUNT(Entry_ID) = 277 COUNT(Entry_ID) / 60 = 4.6 SELECT ROUND((COUNT(Entry_ID)/60),0) AS PageCount FROM eSRS_BilLData WHERE Request_ID = 1 Can someone help me here? I thought Round would work. I need anything over 4.0 to be displaed as 5 pages. Ryan ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
