MEMO FIELD SHOWS UP AS TEXT FIELD WHEN CREATING NEW TABLE

[franksirvent]

hi,

I am creating a table via SELECT ... INTO.... etc

It all runs well, however a MEMO field which is over 255 characters in length some of the data, the new table has the field as TEXT instead of MEMO

How do I 'force' the query to create the new table, and keeping the correct format for each field?

All other fields (over 50) seem to be correct, except this one.

thanks in advance

 

[franksirvent]

please disregard

i founda solution