Unanswered: converting to number and insert number
Hi need hel again. I have a column in the access table that contain text. i have a few record with text like this 100,000,000.00K. The problem now is i want to convert them to numbers where the K indicate to add three more zero (100,000,000,000.00) before the decimal place. So can i input any code in query to do this or there is a way to write VB code to solve the problem. Appreciate the help. Thanks.
Hey thanks frosty1, Thanks for your help...anyway i solve the problem using query but it was a long process. Anyway thanks...will try using the code. But how to connect this piece of code to the table? Sorry i'm a newbie so do not no how the process. Is it using module? then link up with the form?
you put the function into a public module (not your form module). then any time you need to convert a number in your code just call the function like this example which would convert a textbox that had your number: