Eileen- All rounding in Access uses "banker's" rounding that rounds an exact 0.5 to the nearest even value. So, 892.5 rounded to an integer = 892. On the other hand, 893.5 rounds to 894. Why do you want to round to an integer? What is the business problem you're trying to solve?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of eileen1309 Sent: Monday, January 30, 2006 6:28 PM To: [email protected] Subject: [ms_access] help with rounding to nearest dollar Hi everyone, I have an issue using MSAccess 2003 i have a query with a calculated field and this field is set to currency. If the final result ends in .5 it rounds down and i need it to round up for instance 892.5 = 893 892.4 = 892 Using the Round() it will truncate and and reflect a round down instead of a proper round. Any help would greatly be appreciated. Thanks Eileen Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> 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/
