Formula Fields in Access

DanielMcCarthy · Sep 18, 2000

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 · Sep 18, 2000

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 · Sep 18, 2000

Thanks,

Using an update query worked.

[sig][/sig]

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Formula Fields in Access

DanielMcCarthy

Technical User

Phooey

Programmer

DanielMcCarthy

Technical User

Similar threads

Part and Inventory Search

Sponsor