Heenan, Lambert
Lambert.Heenan at AIG.com
Fri Jun 6 10:16:43 CDT 2008
Try: round(YourFpNumber + 0.5,0) Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows Sent: Friday, June 06, 2008 11:10 AM To: accessd Subject: [AccessD] Rounding UP In Access 2003, is there a way to ALWAYS round UP to the next whole number? I am trying to calculate stock needed to create parts and need to determine whole pieces of stock, not partials. TIA Jeff Barrows -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com