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.