Link to home
Start Free TrialLog in
Avatar of georgefant_owt_net
georgefant_owt_net

asked on

How to extract the last 4 characters of a string in Access design view

I'm working in Access, design view where I'm trying to extract the last 4 characters of a string. Example:  omega1234 (want the last 4 digits). I've tried the Right function but can't get it to work. Does anyone have an easy solution?
Avatar of dorianm
dorianm

Why doesn't RIGHT() work ?

RIGHT( myString, 4 )

Open in new window

Can you attach the code you currently have?
Avatar of georgefant_owt_net

ASKER

This is what I'm entering:  Right([login],4) and it comes up blank.
ASKER CERTIFIED SOLUTION
Avatar of dorianm
dorianm

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks! It works!