Hi John, The issue at hand is currency values the client would like to take the US Standard that if it ends in .5 or higher to round up to the nearest whole dollar, and .49 and lower round down to the nearest whole dollar. I was able to find a solution to the issue that has help me out and I do appreciate your response. I never realized that there were so many acceptable methods to rounding.
Thanks Eileen. --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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/
