Text to Columns

[Dan]

Hello,

I'm trying to build a query that will take the first four
words from a field and split them into columns. For
example if in one table I have a record with the
vale: "The table is made of wood", I would want a query
where the Column1="The" Column2="table" Column3="is"
Column4="made".

Any ideas on how this can be accomplished?

 

[JohnFol]

There is a split function you could use, but it requires code to dimension
the holding array. I would suggest you leave the query as is, and use code
on the OnCurrent of the for (or report) where you display the data to do the
splitting.