String

[IanT]

Hi

I have field with data such as:

YORK, @ YO17ET@
CHELMSLEY WOOD, @ B376RH@
DUDLEY, @ DY11NT@

I want to extract the data between the two @, for example:

YO17ET
B376RH
DY11NT

Can anyone help!

 

[spikepl]

Help yourself using the Access string functions: http://www.techonthenet.com/access/functions/