dropping in decimals

[colleen]

I know how to make the import file place a decimal and 2
zeros at the end. That is NOT what I want to do. I have
a .txt file i'm importing to a table. It contains data
(dollars) in the following format...22700 or 535
I want access to place a decimal point TWO places from the
right or make it read 227.00 and 5.35. All i can get it
to do is convert them to 22700.00 and 535.00.
Can anyone help me set up my table to have access have a
SET decimal 2 places from the RIGHT in the data, no matter
how many digits the raw data contains?
Thanks

 

[Armen Stein]

I know how to make the import file place a decimal and 2
zeros at the end. That is NOT what I want to do. I have
a .txt file i'm importing to a table. It contains data
(dollars) in the following format...22700 or 535
I want access to place a decimal point TWO places from the
right or make it read 227.00 and 5.35. All i can get it
to do is convert them to 22700.00 and 535.00.
Can anyone help me set up my table to have access have a
SET decimal 2 places from the RIGHT in the data, no matter
how many digits the raw data contains?
Thanks

Hi Colleen,

I'm not sure how to do that during the import, but you could always run
an update query to divide all the numbers by 100.

Update To for MyField: [MyField]/100

Not the exact answer you were looking for, but it would work. Anyone
else know how to do this during import?