Formula Fields in Access

[DanielMcCarthy]

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? [sig][/sig]

 

[Phooey]

Are you using an import specification?

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. [sig]<p>Phooey<br><a href=mailto:Andrew.j.harrison@capgemini.co.uk>Andrew.j.harrison@capgemini.co.uk</a><br>Otherwise known as Windy Bottom.[/sig]

 

[DanielMcCarthy]

Thanks,

Using an update query worked.

[sig][/sig]