Pull part of data from a string

L

lindag

I have a field that could contain various different characters before
and after ###-###-####.

I want to extract ###-###-#### from the fields but I keep getting
errors.

Any thoughts or suggestions would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting part of a field 2
Excel Help to copy information from one row at a time to another sheet 1
Prompt for a subform text field 2
Query field size quandry 2
Access Form - Lock Fields from Editing 0
This seems like an easy lookup...what am I missing? 4
Access Pulling a variable length string in MS Access 0
Trying to use DLookup 3

Top