Urgent !!! Pl.. help "coverting text into numeric"

[ksraju6]

Hi !

Thanks in advance.

I have a text field in my access table, which is to be converted into number before sending it to another table . this field has leading zeros in the front eg:000074. But when i convert it into number it is becoming 74 .

How can I Control that ? I want it to be shown as number 000074 .

Is there a way to get it converted to number 000074 ???

PL. help me out !

hirshfielda@aetna.com

 

[jebry]

Hi!

Store it as a number and format it whenever you display it.

hth
Jeff Bridgham
bridgham@purdue.edu