Make Table Queries and Concatenated Memo fields

[susanmgarrett]

I have a Make Table query that includes a new field concatenated from a numeric field and a memo field, with some assorted text elements -
Issue Description:"("&[number]&") "&[Description]

When I run the Make Table, the new field "Issue Description" is created as a text field, NOT as a memo field.

Is there any way to insure that this field is created as a memo field.

Thanks.

Susan

 

[llkhoutx]

Create the table first with the memo field, then delete all records, if any (after use), and then use an update query to stuff the memo field.