Text to Columns

  • Thread starter Thread starter Dan
  • Start date Start date
D

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?
 
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.
 
Back
Top