Hello
My company uses an access 2000 database which I am unable to alter. I instead copy out the tables I need. In the company DB the Cost field is formated as a number and shows up as 775 meaning 7.75. Of course when I copy the table I get the same results. 775 instead of 7.75 and 1125 instead of 11.25 Is there a formula I can use to conver this to the correct format I desire
Thanks
Bob
My company uses an access 2000 database which I am unable to alter. I instead copy out the tables I need. In the company DB the Cost field is formated as a number and shows up as 775 meaning 7.75. Of course when I copy the table I get the same results. 775 instead of 7.75 and 1125 instead of 11.25 Is there a formula I can use to conver this to the correct format I desire
Thanks
Bob