Why is Access rounding up my numbers!? 1

[lmn]

Hello,

I have a table where I enter bid information - per square foot. Sometimes the difference between a winning bid and a losing bid is 2 cents. For example, a winning bid may be $17.02 per square foot and the losing bid is $17.04 per square foot.

When I enter this information into access (no matter what data type I select or how many decimal places) - Access lists them both as $17. I have no issues with this - but I know my client definitely will since they want to see things down to the penny.

I figure I shouldn't waste any more time trying to figure this out on my own and someone has probably went through it before and it's something simple........

Thx,
Lisa

 

[jdegeorge]

Are you sure that the DATA TYPE propery of the field in the table is CURRENCY and that you changed DECIMAL PLACES to 2?

Jim

"Get it right the first time, that's the main thing..."

 

[ksgirl2]

If you are using number instead....change the number field length to DOUBLE. This will stop access from rounding it off. In fact i have my access properties set to default all my numerical fields to double just for that reason.

hope this helps.


m

 

[jdegeorge]

Check this FAQ for some good ideas...

http://www.tek-tips.com/faqs.cfm?spid=705&sfid=3734

Jim DeGeorge