Instead of using a MakeTable query, create the table structure you want and
then use an append query to fill in the data.

HTH
Dale

"kvogler" wrote in message
...
I have a make table query in Access. I am attempting to create a "MEMO"
type
field in an expression. If I have wkcomment: M_COMMENT and
M_COMMENT is already defined as a "MEMO" field then the resulting table
has a
field "wkcomment" with type "MEMO". If I have wkcomment: M_COMMENT &
Cstr(M_DATE)
then the resulting table has a field "wkcomment" with type "TEXT". How can
I
force the result field to be type "MEMO"?