Recovered foxpro table

seat172

Registered User.
Local time
Yesterday, 19:09
Joined
Jun 30, 2004
Messages
25
Guys, i have a recovered Foxpro table, the problen i have is the numbers have the wrong format. To be exact, 63 should be 0.63, 1200 should be 12.00, 4250 should be 42.50. In other words i need to put in a decimal place two places to the left of each number. How do i do this on import ? Do i have to run a query and make a new table? If so what function and expression do i use?

Many Thanks:)
 
Can't you simply put something like:

MyNumber * .01

Say in an update query?
 

Users who are viewing this thread

Back
Top Bottom