Hexadecimal To 30 Digit Text String Problem
Posted on 2007-11-30
I have a field, CHECK_ACH_NO, with the following format:
I need it converted to this: 458712000000000000000000000000, or at least the first 10 digits.
I'm using this to convert: CStr([CHECK_ACH_NO]), however, it does not work at all. When I query the table, the output looks exactly the same as it did before the query, 4.58712E+29. Is there another method I can use to convert this to a text string or a number? I only have to have the first 10 digits of the 30 that are there, the last 20 are just zeros, but all 30 would be fine too.