Joining Memo Fields

[Njliven]

Here is my problem. I have text fields that I want to join and make all one field. I turned these into memo fields to hold all the characters. Now I joined them into a new field with a query, like this. NewDesc[Desc1]&" "&[Desc2]&" "[Desc3].

Now I want to make a new table with the new field, however it does not keep the memo status, it goes to a text field and cutting off anything over 255 characters. Is there anyway to tell this to be a memo field so it keeps all the data. Thanks!

[alansidman]

Instead of a maketable query, try creating a new table with all the fields you wish and formatted as desired. Take your query that you have merged the data in and use it as a record source for an append query. Append the data in the query to the newly formed table.

Alan

[Njliven]

Should of thought of that myself. Worked like a charm. Thanks!