News1 min ago
Querying an Access 97 Memo Field
I've inherited an Access 97 db at work. One of the fields in the main table contains error codes and descriptions, followed by a semi-colon.
I want to query the memo field to append each error into a different table. Then I can report on how many errors were made of each type...
There is no set length for each error description, but each one is seperated by that semi-colon.
Memo field example:
ERR01 - Description01; ERR07 - Description70; VDS32 - Description of VDS32;
Can anyone tell me how to buid this append query?
Thanks for any help.
I want to query the memo field to append each error into a different table. Then I can report on how many errors were made of each type...
There is no set length for each error description, but each one is seperated by that semi-colon.
Memo field example:
ERR01 - Description01; ERR07 - Description70; VDS32 - Description of VDS32;
Can anyone tell me how to buid this append query?
Thanks for any help.
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by tpreece01. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
Visual Basic would be the best way.
Basically you use the Split() function to separate the field contents into array variables and then write these values to the table in a loop.
Another way might be to export the field with a suitable delimiter and then reimport using the semicolon and hyphen as delimiters. It would be a kludge if made to work.
Basically you use the Split() function to separate the field contents into array variables and then write these values to the table in a loop.
Another way might be to export the field with a suitable delimiter and then reimport using the semicolon and hyphen as delimiters. It would be a kludge if made to work.
Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.