Make Table query Memo field

F

FPSC

I have a SQL query that make a table with a very long text on one column.
When I run the query without making the table the text is complete, but when
I Make the Table the field appear truncated to 255 characters.

I need to keep that column as a Memo not as a text, so all the characters
are kept and not truncate to 255.

What is the code to do that?

Any help will be appreciated.

Thank you.
 
G

Guest

Hi,

Memo fields are troublesome at times. A quick fix would be to make a
table in advance and change your make-table query to an append query. This
should maintain the length of your field.
 
F

FPSC

Thank you very much for your suggestion.
It works perfectly that way.
Thanks again Chris.
 

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

Make Table Query Truncating Memo Field at 255 Characters 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Query field size quandry 2
disctinct query memo field 3
How can I convert text field to memo field in a query 10
Totals query and Memo field 3
Append to SQL Server 3
memo field in the select query 2

Top