Make table truncates text concatenated using fnConcatenate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale Fye - 11 Apr 2007 20:48 GMT

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?

Signature

Email address is not valid.
Please reply to newsgroup only.

Reply to this Message

John W. Vinson - 11 Apr 2007 21:30 GMT

>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]

Reply to this Message