Hi all:
I am trying to figure out how (if it's even possible) to update a field with the string of a parameter query search result from a different field? It doesn't have to be all in the same query.
I have a memo field that I want to search on with a parameter query, and then plug the text from the search into a different field.
So, source field called MEMO, destination field called FURNITURE.
Search for 'chesterfield' in MEMO, plug 'chesterfield' into FURNITURE field for returned records.
I'm going to be doing this hundreds of times with different strings, so I think it has to be a parameter query (unless there's a better option that's equally dynamic). Or, is there another way to bulk-update?
Oh, and I'm running Access2000 on NT4.0.
Any help is greatly appreciated. And Hello from Vancouver, Canada.
I am trying to figure out how (if it's even possible) to update a field with the string of a parameter query search result from a different field? It doesn't have to be all in the same query.
I have a memo field that I want to search on with a parameter query, and then plug the text from the search into a different field.
So, source field called MEMO, destination field called FURNITURE.
Search for 'chesterfield' in MEMO, plug 'chesterfield' into FURNITURE field for returned records.
I'm going to be doing this hundreds of times with different strings, so I think it has to be a parameter query (unless there's a better option that's equally dynamic). Or, is there another way to bulk-update?
Oh, and I'm running Access2000 on NT4.0.
Any help is greatly appreciated. And Hello from Vancouver, Canada.
Last edited: