In excel there is an mround function that I'm sure is in access. So it would be final=mround(initialnumber,.5).
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Monday, January 09, 2006 10:19 PM To: [email protected] Cc: [email protected] Subject: [ms_access] RE: [MS_AccessPros] Help with rounding off Rajesh- Similar answer to what I gave you earlier, but now it's clear you want to round down exact .5 numbers: Round((<formula result> * 2)-0.5)/2 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 RAJESH DESAI Sent: Monday, January 09, 2006 10:11 PM To: Access1; Access2; Access3 Subject: [MS_AccessPros] Help with rounding off Hi, I want to round the rsults of my calculation as per following examples. Formula Result Required Figure 1.25 1.00 1.50 1.00 1.75 1.50 1.95 1.50 2.10 2.00 How to do this in VBA code. Please help. Regards, Rajesh Desai --------------------------------- Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever. [Non-text portions of this message have been removed] Yahoo! Groups Links 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/
