View Single Post
  #1  
Old January 18th, 2006, 12:25 AM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default How can I concatenate a MEMO field and a text field?

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