F fatbloater Registered User. Local time Today, 22:54 Joined Sep 28, 2004 Messages 36 Oct 12, 2004 #1 What is the easiest way to roundup a currency value to the nearest 10pence?
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 22:54 Joined Jul 9, 2003 Messages 17,411 Oct 12, 2004 #2 There are loads of examples on rounding up or down on the internet I suggest you do a search, bearing in mind that different methods of rounding give you different answers.
There are loads of examples on rounding up or down on the internet I suggest you do a search, bearing in mind that different methods of rounding give you different answers.
F fatbloater Registered User. Local time Today, 22:54 Joined Sep 28, 2004 Messages 36 Oct 12, 2004 #3 Can anybody else HELP me?
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 22:54 Joined Jul 9, 2003 Messages 17,411 Oct 12, 2004 #4 This is a "Bankers Rounding" example.... Attachments BankersRounding.zip BankersRounding.zip 18.2 KB · Views: 141
J JinaneKarhani Registered User. Local time Today, 14:54 Joined Aug 31, 2004 Messages 15 Oct 12, 2004 #5 thx uncle Gizmo, hope u will be caught by some1 ..
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 22:54 Joined Jul 9, 2003 Messages 17,411 Oct 12, 2004 #6 Opps!!! That previous example has an error in it, try this one, not tested so if you find any problems with this one please post back ! Attachments BankersRounding.zip BankersRounding.zip 10.8 KB · Views: 157
Opps!!! That previous example has an error in it, try this one, not tested so if you find any problems with this one please post back !
F fatbloater Registered User. Local time Today, 22:54 Joined Sep 28, 2004 Messages 36 Oct 12, 2004 #7 after looking at your example i am unable to open my database, is there something dodgy in this zip file?
after looking at your example i am unable to open my database, is there something dodgy in this zip file?
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 22:54 Joined Jul 9, 2003 Messages 17,411 Oct 12, 2004 #8 More Information please ! Do you get any error messages? Have you tried switching your machine off and back on again ?
More Information please ! Do you get any error messages? Have you tried switching your machine off and back on again ?