G Guest Mar 28, 2007 #1 I have a field that contains information to extract. i.e." billing change $12.16." I want to only extract 12.16
I have a field that contains information to extract. i.e." billing change $12.16." I want to only extract 12.16
G Guest Mar 28, 2007 #2 If the data ALWAYS has a period on the end and a $ sign in it then use this -- Left(Mid([YourFieldName], InStr([YourFieldName], "$"), 254), Len(Mid([YourFieldName], InStr([YourFieldName], "$"), 254))-1)
If the data ALWAYS has a period on the end and a $ sign in it then use this -- Left(Mid([YourFieldName], InStr([YourFieldName], "$"), 254), Len(Mid([YourFieldName], InStr([YourFieldName], "$"), 254))-1)
