[AccessD] Rounding UP

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



More information about the AccessD mailing list