I created a make table query that selects between two memo fields and places the result in a third field. In the resulting table the selected field has the data type text rather than memo. This causes a truncation of the information in the selected memo field. Is there a means to instruct the query to create a memo field for its text output?
Field Types in a Query Output
- Thread starter slrphd
- Start date
ColinEssex
Old registered user
- Local time
- Today, 06:26
- Joined
- Feb 22, 2002
- Messages
- 9,451
why not use an append query? (after deleting the exisiting records first)
Col
Col
susanmgarrett
Registered User.
- Local time
- Yesterday, 22:26
- Joined
- Dec 7, 2004
- Messages
- 41
Looking to set a query output to memo from text
I have a similar problem. I have a query, which I use to fill an MS Word report document. I concatenate two memo fields in the query, but the resulting new field is a text field with a 255 limit.
Is there any way to set the data type for that new field inside the query so that it results with a memo field? I'd like to leave this as a query because the information is extremely fluid.
Thanks!
Susan
I have a similar problem. I have a query, which I use to fill an MS Word report document. I concatenate two memo fields in the query, but the resulting new field is a text field with a 255 limit.
Is there any way to set the data type for that new field inside the query so that it results with a memo field? I'd like to leave this as a query because the information is extremely fluid.
Thanks!
Susan
susanmgarrett
Registered User.
- Local time
- Yesterday, 22:26
- Joined
- Dec 7, 2004
- Messages
- 41
My work-around
This question was never answered.
My work around was to turn the Query into a Make Table Query for the first time it was run. I changed the text field for the new table into a memo field. I then changed the query to an append query and created a second query that was a delete query. I joined the two in a macro and automated the button responses.
The process is:
I activate the macro.
The delete query empties the old data from the table.
The append query adds the new data to the empty table.
I run the word document from the table.
Hope that helps. It's an ugly solution. but it is a solution and it's fairly easy to automate with the macro.
Regards.
Susan
This question was never answered.
My work around was to turn the Query into a Make Table Query for the first time it was run. I changed the text field for the new table into a memo field. I then changed the query to an append query and created a second query that was a delete query. I joined the two in a macro and automated the button responses.
The process is:
I activate the macro.
The delete query empties the old data from the table.
The append query adds the new data to the empty table.
I run the word document from the table.
Hope that helps. It's an ugly solution. but it is a solution and it's fairly easy to automate with the macro.
Regards.
Susan
crizzottzz
New member
- Local time
- Today, 01:26
- Joined
- Aug 20, 2005
- Messages
- 4
If doing:
[Field1], [Field2], Field3: [Field1] & [Field2]
and ending up with field type 'text' in the resulting table, try using Query->Paramenters from the menu and setting up Field3 as a memo there.
[Field1], [Field2], Field3: [Field1] & [Field2]
and ending up with field type 'text' in the resulting table, try using Query->Paramenters from the menu and setting up Field3 as a memo there.
