If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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"? |
#2
|
|||
|
|||
How can I concatenate a MEMO field and a text field?
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"? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
text field cannot grow | John | Setting Up & Running Reports | 13 | January 3rd, 2006 08:16 AM |
Form Text Box to Table Memo Field? | G | Using Forms | 0 | June 10th, 2005 07:17 PM |
Memo Field to Text Field Conversion | Scott | General Discussion | 2 | March 31st, 2005 12:09 AM |
Condensing Text fields into a Memo field - Need to retain line spa | Doc Don Sturgiss | General Discussion | 3 | December 28th, 2004 02:43 AM |
Please Help! A2K memo field shows eror "Too much text to edit" | Lauren Wilson | Using Forms | 1 | August 12th, 2004 04:02 AM |