Erika,
Good question! -- in this case, it was an audit requirement for exact
calculations re: annual pay increases under a union contract.
The payroll folks were giving us (IT) the data in a Currency field, with
formatting showing 2 decimal places. They were unaware that internally it
contained 4 decimal places.
We probably could have "proved" to the audit folks that the rounding always
worked correctly, but it was politically easier to simply process the file
to 2 real decimal places, send it back to the payroll folks to "certify",
then import the certified file into Oracle "untouched by human hands".
(As you may have encountered, sometimes it's hard to convince folks and is
just easier to give them what they ask for...)
Your mileage may vary <grin>.
Ben
-----Original Message-----
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 10:21 AM
To: [EMAIL PROTECTED]
Subject: RE: Trouble with controlling decimal places in Access table
curre ncy datatype
Ben,,
Why would you want to control what the database has in it to begin with? You
can always format the display..... is it because of exact calculations? The
results are always off because of the four digits after the decimal? (ie,
gas prices.... 1.699999, blah,blah,blah)
Just curious....
(Although they say, curiosity killed the cat!)
Erika
"Microsoft, by some accounts, the second most capitalized company on the
planet, is the only corporate colossus in history whose entire product line
could be eliminated with a giant magnet." - David Shenk
-----------------------------------------------------
Instant Messenger Access
AIM: WebErika5 | Yahoo: WebErika | MSN: WebErika
-----------------------------------------------------
Erika L. Walker, VP, RUWebby, LLC
http://www.ruwebby.com
973-626-2412 Mobile | 973-244-9120 Office
153 Rutgers Lane, Parsippany, NJ 07054
-----------------------------------------------------
Website Design/Programming
Database Integration
Allaire Partner - ColdFusion
AskMe.com Expert: WebErika
-----------------------------------------------------
-----Original Message-----
From: Braver, Ben [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 12:34 PM
To: CF-Talk
Subject: RE: Trouble with controlling decimal places in Access table
curre ncy datatype
Hubert,
>From MS Access 97 help screen:
"Currency data type
A data type that is useful for calculations involving money or for
fixed-point calculations in which accuracy is extremely important. This data
type is used to store numbers with up to 15 digits to the left of the
decimal point and 4 digits to the right. The type-declaration character in
Visual Basic is @."
I've had to to stuff like multiply, round, divide to get around this. Yukk.
HTH
Ben
-----Original Message-----
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 6:33 AM
To: CF-Talk
Subject: Trouble with controlling decimal places in Access table
currency datatype
Hi,
I'm having trouble controlling the number of decimal places that is used by
a column in an Access table with currency datatype. Although I set the
number at 2, I keep getting 4. I'd appreciate any advice.
Sincerely,
---
Hubert Earl
ICQ#: 16199853
AIM: hubertfme
My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
