Text to Number formatted (1 Viewer)

Gismo

Registered User.
Local time
Today, 17:42
Joined
Jun 12, 2017
Messages
548
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, 15:42
Joined
May 23, 2011
Messages
3,972
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, 17:42
Joined
Jun 12, 2017
Messages
548
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 (Users: 0, Guests: 1)

Top Bottom