Make table truncates text concatenated using fnConcatenate

[Guest]

I have a MakeTable query which uses the fnConcatenate( ) function to merge a
bunch of information into a single field. Unfortunately, the field length
exceeds 255 characters and the MakeTable tries to dump this into a text
field, rather than identifying that the field should be a memo field.

I know I could create the base table and import the data from my query into
that table, but I would prefer to make this table on the fly, and then delete
it when I am done with it.

Any recommendations?

 

[John W. Vinson]

I know I could create the base table and import the data from my query into
that table, but I would prefer to make this table on the fly, and then delete
it when I am done with it.

Any recommendations?

If you want the text to end up in a Memo field, AFAIK you have no choice but
to create the table first.

MakeTables are rarely (IME) necessary. If you want a scratch table, just
create it once, keep it around, and empty it when you're done with it.

John W. Vinson [MVP]