Hi All,
I'm new to this board and have a question about a function that might be easier in VB than straight ms access query writing.
The problem I am having is that I have a field that contains numbers separated by commas, these are coded fields which relate to another table with the decoded txt for each #.
What I need to be able to do is run an update on a table to insert the decoded text where the corresponding number is.
Example: Table1 coded field name is CodedField, Table2 decoded txt field is DecodedTxt and another field for CodeNumber to relate to CodedField
I've tried using the Replace() func along with Dlookup, but its not working.
Any help is appreciated. Like i said, VB is fine if I can just call a function in an update query or if its easier in sql/query writer that'd be great too.
Thanks
stan
I'm new to this board and have a question about a function that might be easier in VB than straight ms access query writing.
The problem I am having is that I have a field that contains numbers separated by commas, these are coded fields which relate to another table with the decoded txt for each #.
What I need to be able to do is run an update on a table to insert the decoded text where the corresponding number is.
Example: Table1 coded field name is CodedField, Table2 decoded txt field is DecodedTxt and another field for CodeNumber to relate to CodedField
Code:
Codes 1=x, 3=y, 5=O (for example!)
CodedField = 3,5,1
Should in turn read: y, O, x
I've tried using the Replace() func along with Dlookup, but its not working.
Any help is appreciated. Like i said, VB is fine if I can just call a function in an update query or if its easier in sql/query writer that'd be great too.
Thanks
stan