Hmm, I assumed there would be a round up function, but surprisingly Access doesn't have one. Fortunately there is Google...:-)
Here's what I found on line, it should do the trick. Dim i As Double Dim iStore As Integer i = 4.1 iStore = Int(i) + 1 Debug.Print iStore Craig Gross Sr. Pub Reporting and Profitability Analyst Baker & Taylor 1120 U.S. Highway 22 East Bridgewater NJ 08807 908-541-7197 Tel 908-541-7862 Fax [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of setiawanboby Sent: Wednesday, June 21, 2006 6:48 AM To: [email protected] Subject: [Access VBA Central] Always Round UP How can I always round up a decimal number? Say I have a number: 4.1, I want it to be stored as 5. Please help. Thank you. Boby Setiawan This email and any attachments contain information from Baker & Taylor which may be confidential, privileged and/or protected by other legal rules. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or use of the contents of this email is prohibited. If you have received the email in error, please notify us by reply email immediately and then delete the email and your reply from your email system. NOTE: Baker & Taylor accepts no liability for the contents of this email. This email shall not operate to bind Baker & Taylor to any contract, order or other obligation. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
