Re: Create Column/Table from multiple words in a field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Frank

This should help you get started.

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

HTH


--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

FMS Advanced Systems Group
http://www.fmsasg.com/


"Frank H via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in message
news:534896E0B9A3F@xxxxxxxxxxxxxxxxxxxx
>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.
>
> --
> Best,
> Frank


.



Relevant Pages

  • Re: if... elseif statement
    ... Rob Mastrostefano ... FMS Professional Solutions Group ... FMS Advanced Systems Group ...
    (microsoft.public.access.formscoding)
  • Re: Generate series of numbers
    ... >> If I specify a range from 2000 to 2038, what ruleallow me to display ... >> Rob Mastrostefano ... >> FMS Professional Solutions Group ...
    (microsoft.public.access.forms)
  • Re: Join numbers to form Array calculation
    ... >> Rob Mastrostefano ... >> FMS Professional Solutions Group ... >> Software Tools for .NET, SQL Server, Visual Basic & Access ...
    (microsoft.public.access.modulesdaovba)
  • Re: if... elseif statement
    ... >> FMS Professional Solutions Group ... >> Software Tools for .NET, SQL Server, Visual Basic & Access ... >>> Public Function ValidatePg1() ...
    (microsoft.public.access.formscoding)
  • Re: Incrementing Mixed Field
    ... >> FMS Professional Solutions Group ... >> Software Tools for .NET, SQL Server, Visual Basic & Access ... >> FMS Advanced Systems Group ...
    (microsoft.public.access.formscoding)