[AccessD] Rounding Problem?

Rocky Smolin rockysmolin at bchacc.com
Fri Oct 19 13:31:43 CDT 2012


Single.  I changed it to Double to see if that made a difference but it did
not.

Now I'm thinking of a major kludge where I take the number and multiply by
10 to the power of the number of decimal places, add .5, take the FIX() and
divide back.  Really would hate to go that route.  There's gotta be an
answer here somewhere.

TIA

Rocky


R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Friday, October 19, 2012 11:21 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Rounding Problem?

What's the data type of the underlying field in your table?

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, October 19, 2012 2:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Rounding Problem?

However, Gustav, I do see one line item which displayed 3000 1.3000
3900.0000 when formatted Standard but when formatted Currency displays 3000
1.3000 3899.9998.  

This is the same part number as the line before it which displays 3500
1.3000 4550.0000 correctly whether formatted Currency or Standard.

Any clues there?

TIA

Rocky


-----Original Message-----
From: Rocky Smolin [mailto:rockysmolin at bchacc.com]
Sent: Friday, October 19, 2012 11:07 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Rounding Problem?

Could it be that simple?  Wait...let me try...rats..no cigar.  The sub total
still comes out 14,559.9998.  

And if I use Currency format it shows the $ which I need to not see as the
app supports multiple currencies and there's a user preference for their
currency symbol.  Which is why I went with standard. 

Any other ideas?  I'm stumped.

Thanks

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, October 19, 2012 10:44 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Rounding Problem?

Hi Rocky

That is most likely because you are not using data type Currency.

If I do that, the sum runs to 14560.0000

/gustav


>>> rockysmolin at bchacc.com 19-10-12 19:31 >>>
Dear List:
 
I have an app in which I allow the user to set a preference for the number
of decimal places they want to display in currency fields.
 
In the purchasing module this works well for 1, 2, or 3 decimal places.  But
I have a user who sent me a database where he has selected to display 4
decimal places (God knows why) and a PO with 6 line items.  The Quantity
Ordered, Unit Price, and Extension are as follows:
 
3500 1.3000 4550.0000
3500 1.3000 4550.0000
3000 1.3000 3900.0000
2000 0.2600   520.0000
2000 0.2600   520.0000
2000 0.2600   520.0000
 
The sub-total should add up to 14560 and with 2, or 3 decimal places it
does.  
 
But if I go to 4 as shown then the sub total (Control Source:
=Sum([fldPODUnitCost]*[fldPODQuantityOrdered]) )shows as 14,559.9998.  One
or more of those lines apparently does not have an exact decimal equivalent
in binary but they all display correctly in the detail.
 
Both text boxes are Format Standard.
 
Any clue what the solution is?
 
MTIA
 
Rocky Smolin
Beach Access Software
858-259-4334
www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
<http://www.e-z-mrp.com/>
Skype: rocky.smolin


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list