Text to Number formatted

[Gismo]

Hi All,

i have text field which I am only extracting the last for digits then I need to covert this text to a number Integer

#SN: Format(Right([IW73 TBL]![Functional loc#],4),[Fixed])#

not getting the required result
getting a enter parameter value and outcome is an #Error

 

[bob fitz]

Perhaps:
SN: Right([IW73 TBL]![Functional loc#],4)

Or
SN: Right([Functional loc#],4)

BTW you shouldn't use special characters like "#" in the names of objects like fields

 

[Gismo]

Perhaps:
SN: Right([IW73 TBL]![Functional loc#],4)

Or
SN: Right([Functional loc#],4)

BTW you shouldn't use special characters like "#" in the names of objects like fields

i had it the way you suggest, works fine
#SN: Right([IW73 TBL]![Functional loc#],4)#

But now i need to format it to a number
#SN: Format(Right([IW73 TBL]![Functional loc#],4),[Fixed])#

 

[bob fitz]

Try:
SN: CInt(Right([IW73 TBL]![Functional loc#],4))