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
