currency conversion in AccessLocked
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?