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

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

Dale Fye

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I convert text field to memo field in a query 10
Dates in a memo field 3
Can rich text format (memo) carry over in a make table query? 1
how can I specify text criteria when querying a memo field 1
Can I use totals on one field and still have a memo field? 4
Select Noted Memo Field 4
Query field size quandry 2
memo field in the select query 2

Top