Remove Number from text string

[Zonie32]

I have field with a list of different numbers like this: (All different lengths)

DescNo.
AB1234
CDE33333
TCBY88

How can I return just the Alphabetic letters in a new field? I want the numeric values to drop off.

 

[SteveR77]

This will do what you need.

http://www.mvps.org/access/strings/str0002.htm

Put the function in a module and the you'll be able to
use the function in your query as follows -

fExtractStr([DescNo])


HTH,


Steve