Software

Ask something
Discussion Locked

currency conversion in Access

0 helpful
4 replies

by john.a.wills

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a table with a currency field. I want to convert the currency field to a number with two decimal places for export. I insert into a long integer field in a second table, and the cents and the decimal point get lost. When I export I get the numbers left justified. What type specifications should I be using in my second table?

4 replies

by john.a.wills

When I make the field in the second table fixed I get suitable-looking numbers. But I still get left justification at export.

by john.a.wills

No, the numbers still came out left-justified at export, with no decimal points and with the (all zero this time) cents missing.

by wyscavern

I have a similiar problem. Although I got all the numbers to come through including the cents, it keeps rounding up to the nearest dollar and I need exact amounts. Here is my code for formatting. I need extra zero's in front of the actual amount so I can download into another database.
Right((String(12,"0")+Replace(Replace(FormatNumber([Cash Receipt Total],0),".",""),",","")),10)+'00'.
The formatting works perfect for me, but when I have 22.50 it comes out to be 2300, which will not work. I cannot figure out why it is rounding or where in my formula I tell it to round???

This discussion is closed to new replies.