How to get last digit? 2

[knuckelhead]

I have a 8 character field named formulaID which is text in tlbFormula.

In a query, i need to get the last digit into a separate calculated qry field. so that means the 8th character is the last digit. so what is the syntax in the calculated field which we can call "LastDigit".

thanks

 

[PHV]

In the query grid:
LastDigit: Right([formulaID], 1)

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

 

[Golom]

LastDigit: Right(formulaID,1)

or

LastDigit: Mid(formulaID,8,1)

 

[knuckelhead]

thanks for the instant answers. this is a great site.
it works!
i will send a donation with "stars".
glen