Move data from middle of field into a new field...

R

Ron

I've seen several related posts but haven't found one that quite achieves
what I'm trying to do:

I have a table with one memo field: [FiledData]. The memo field contains a
whole bunch of data of various lengths, but the one consistent piece of data
is a number in the following format:

##########-##-######

It usually appears in the middle of the field, never at the beginning and
only sometimes at the end, so I guess the Mid() function will be used.

I would like to find that data in the memo field, extract it and place it in
a separate field: [AccessionNumber]. I would like this to happen on the
"After Update" event of the [FiledData] field in a form.

Any help in this matter is 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

How to Create an S-Curve from Custom Field? 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
ASK Field Formatting 1
Copy previous record into form field 0
Delete all data after a symbol in a field 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
How to parse data from one field to another 7

Top