Get First 6 digits 1

[knuckelhead]

You helped me with a calculated field named LastDigit: Right([formulaID],1). it worked great in getting me the last digit of an 8 digit code.

I now need to get the first 6 digits. How can i do this?
thanks

 

[PHV]

Left([formulaID],6)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[knuckelhead]

oh boy, what a dummy am I. you are right. I had done the same before posting however, i used mistakenly used the same field name LastDigit and received blank answers. that was because i already used the field name lastdigit within the SAME qry. so i changed the new one to Lastdigit2 and voila, your answer. thanks