Moving chosen strings to another field

[kupe]

Can I get a new field in a query to move certain strings into NewField2,

IIFLeft[FieldA], 6) = "Tomson",

then move it to NewField2, please?

 

[Mile-O]

NewField2: IIf(Left([FieldA], 6) = "Tomson", [FieldA], Null)

 

[kupe]

Thanks, Mile-O-Phile, but it doesn't seem to work.

I want to take any string beginning with the word Tomson - which is among a lot of strings in Field1 - and to have it moved into into Field2.

I can extract all strings like that with a select query, of course, but I thought it would be handy to do it as a new field in a query.

 

[Mile-O]

You can't "move it into Field2" - you have to define Field2 to accept it

 

[kupe]

But I have. I must be doing it wrong then. Slapped wrists for me. Sorry, and thanks very much.

 

[kupe]

How could I doubt you, MoP? Terribly sorry. My fault. It's excellent. Most grateful.