how to split out all words in fields with multiple words

[joe789]

Hi Folks,

I am attempting to split out a descriptive field so that each words which may exist in that particular field will be split out into seperate fields ... for example, if the violation field is populated with a four worded description of 'Assualt on Police Officer' I would like to somehow strip out the words so that 'Assualt' and 'on' and 'Police' and 'Officer' are all in seperate fields. I am not sure if this can be done using a simple query in access ... if anyone can offer any suggestions, I would greatly appreciate it.

Thank you,

Joe

 

[Banana]

1) You may have data normalization problem if you need to do that on regular. It may be easier to break out specifics into their own fields. You could, for example, create a list of crimes then look it up to place in the field.

2) To solve your present problem, look at Split() function. VBA help should have some details. If you get stuck with the help file, post back.