Z
zyus
I used access (2003) for report and analysis. I import text data on monthly
basis from other system into access. I've a big issue on data integrity from
the other system where most of the data is not proper (my term). To elaborate
further pls refer below
Other Sys (EmployerFieldName)
Texas Instrument
Texas Inst
Texas Co
In my case the above employer is the same employer and should be refered as
Texas Co.
I intend to create employer tbl in my access and give a proper name (Texas
Co) for the above records in a new field say myemployername without having to
change the original data in employerfieldname.
Is there any way for me to update in myemployername field say those with
"Texas" in employerfieldname will tag as Texas Co in myemployername. OR is
there any better way to handle this problem
hope that my explaination suffice
basis from other system into access. I've a big issue on data integrity from
the other system where most of the data is not proper (my term). To elaborate
further pls refer below
Other Sys (EmployerFieldName)
Texas Instrument
Texas Inst
Texas Co
In my case the above employer is the same employer and should be refered as
Texas Co.
I intend to create employer tbl in my access and give a proper name (Texas
Co) for the above records in a new field say myemployername without having to
change the original data in employerfieldname.
Is there any way for me to update in myemployername field say those with
"Texas" in employerfieldname will tag as Texas Co in myemployername. OR is
there any better way to handle this problem
hope that my explaination suffice