Create Column/Table from multiple words in a field

  • Thread starter Thread starter Frank H via AccessMonster.com
  • Start date Start date
F

Frank H via AccessMonster.com

I need to create a dictionary of words used in a given field.

Need to extract words to create table from a field.

That's it.
 
HTH,
Thank you. The Sub Test works, however I am a newbie, don't know how to
execute the module. :)

Table name is APC, the field name is HCSDesc.

I would greatly appreciate the help.


Frank

This should help you get started.

http://www.mvps.org/access/strings/str0003.htm
Strings: Parsing character separated string into individual components

HTH

--
Best,
Frank


Message posted via AccessMonster.com
 
Back
Top