Formula Fields in Access
Formula Fields in Access
(OP)
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?
RE: Formula Fields in Access
Try linking the table and performing an update query from the linked table into your access table. Any fine tuning can be done at this point.
Phooey
Andrew.j.harrison@capgemini.co.uk
Otherwise known as Windy Bottom.
RE: Formula Fields in Access
Using an update query worked.