[AccessD] Rounding UP

Hi Jeff,

I use this little rounding function in all of my databases:

Public Function RoundUp(ByVal AnyNum As Double, ByVal PlaceCount As Double)
As Double

   Dim X As Integer
   X = 10 ^ PlaceCount
   RoundUp = Int(AnyNum * X + 0.5) / X
   
End Function

Jennifer 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jeff Barrows
Sent: Friday, June 06, 2008 7: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