is there any way to query table to put every word alone ?

Hi sherif,

Look at the attached that will do what I think you are looking for.

Sorry, I didn't see the Access part of the title.

In Access you need to define each field in the table before filling them in. In your question it seems you don't know how many words there will be in the Memo field, or how many fields/columns to define in the beginning. It seems an easier problem would be to make each word it's own record in a table, but that isn't what I think you now want.

I'd be looking for an index number of each field in each record of the Access table. Then you could increment the index and go to the next field to put the memo words in.

The easiest way to do this is to export the table to Excel, us the text to columns feature, then import back into access.

If you absolutely have to do it all in Access, as MarvinP said, you'll need a way to find the max number of words to set up your table. You need to open your original table as a recordset, then loop through each record. You can use a function like this to find the number of spaces. The highest word count should be the number of spaces + 1.

Spaces = Ubound(Split(strRecord," "))

Hope that helps.