Text to Number formatted (1 Viewer)

Gismo

Registered User.
Local time
Today, 10:20
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
 

bob fitz

AWF VIP
Local time
Today, 08:20
Joined
May 23, 2011
Messages
4,717
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

Registered User.
Local time
Today, 10:20
Joined
Jun 12, 2017
Messages
1,298
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

AWF VIP
Local time
Today, 08:20
Joined
May 23, 2011
Messages
4,717
Try:
SN: CInt(Right([IW73 TBL]![Functional loc#],4))
 

Users who are viewing this thread

Top Bottom