Last Four Acct. No.

[Dr. Evil]

Can someone help me with a calculation?

Looking to have calc present only the last four of full acct. number.

 

for example: 123456789 to 6789

 

Any help is much appreciated,

thanks for your time!

 

[comment]

If you mean the last four characters, then that's what the Right() function does.

[Dr. Evil]

Right ( acct_no ; 4 )

 

Easy one! I did not know of this function, or how it worked anyway.

Thanks for pointing it out comment!