G
Guest
Here's the situation. I have a table that has an ID field as well as a
Comment field. Now all of the ID fields are valued except 200, of these 200
null fields, the ID I want is sitting in the Comment Field, but it's not in
the same location in every comment.
How would I tell the criteria to update the null fields with the ID sitting
somewhere in the Comment field?
Here's an example. The ID I want may be T12345678. There's always an Alpha
character, followed by 8 numerics that make up the ID. So where ever the ID
is sitting in the comment statement, I'd want to update the empty field with
the T12345678.
Thank you in advance for any and all assistance! )
Comment field. Now all of the ID fields are valued except 200, of these 200
null fields, the ID I want is sitting in the Comment Field, but it's not in
the same location in every comment.
How would I tell the criteria to update the null fields with the ID sitting
somewhere in the Comment field?
Here's an example. The ID I want may be T12345678. There's always an Alpha
character, followed by 8 numerics that make up the ID. So where ever the ID
is sitting in the comment statement, I'd want to update the empty field with
the T12345678.
Thank you in advance for any and all assistance! )