I have just started working with Access and have a question about scaling fields. I am importing a table from a comma delimited text file. The table contains a field that is numberic i.e. "0000300". The last two characters are decimal places. Is there a way I can tell access that these are decimal places. I know I can divide the field by 100 but where do I do this?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.