Text to Number formatted

Gismo

Registered User.
Local time
Today, 11:57
Joined
Jun 12, 2017
Messages
1,298
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
 
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
 
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])#
 

Users who are viewing this thread

Back
Top Bottom