How can I concatenate a MEMO field and a text field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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
 
Back
Top