Return Characters after a underscore in a Access 2010 query

Return Characters after a underscore in a Access 2010 query

I am having trouble getting the data I need here.

I have a field "USER_FIELD3" which is a String or Text field. which has the following info

EA _10

RL _250

EA _1500

I need to run a query that returns only the numbers or anything to the Right of the Underscore. I can't get the Right function to work unless i give a specific number and as you can see I may have 1 character or 4 characters depending on the conversion.

this must run in a query and not VBA

Mid([USER_FIELD3], InStr([USER_FIELD3],"_") + 1)

as the expression for the CalculatedField/Column in your Query to get what comes after the underscore character.

Copyright © 2007-2012 www.chuibin.com Chuibin Copyright