[AccessD] Find a Word & Put in New Field

Hollis,Virginia HollisVJ at pgdp.usec.com
Wed Sep 24 07:57:51 CDT 2003


This is a real challenge...

Is it possible to search a field for certain text, remove the word for
placement in another field?

We have a part description that lists the document number in the
description. The document numbers are all the same length and all start with
DS-, (ex: DS-MDD-15987-001). But the document number might be anywhere in
the description. The document number needs to be separated out into a field
by itself.

There are over 3,000 records & I really don't want to sit here for days
doing a copy & paste to move the number to a new field.

Any ideas? Or can this be done at all?

Virginia


More information about the AccessD mailing list