Make Table query format

[Kentucky5]

I posted this in the query forum but have had nobody help
me yet so I figured I would try here.


I have setup a make table query, but when the data comes
in it is truncating the data because the row height is
too small. I created a pass through query that brings in
data, then that passthrough query is used for my make
table query. If I run the passthrough query all of the
data comes back but in the make table it does not bring
in all the data and it gets truncated.

Any help would be appreciated.
..

 

[John Vinson]

I posted this in the query forum but have had nobody help
me yet so I figured I would try here.


I have setup a make table query, but when the data comes
in it is truncating the data because the row height is
too small. I created a pass through query that brings in
data, then that passthrough query is used for my make
table query. If I run the passthrough query all of the
data comes back but in the make table it does not bring
in all the data and it gets truncated.

Any help would be appreciated.
.

The HEIGHT!?

A make-table query doesn't display any data. It's an action query; it
just *moves* data; and the height of a control is (or should be)
completely irrelevant to what's actually stored in the table in any
case!

Please a) post the SQL, b) describe the properties of the field being
updated, and c) post an example of how data is being truncated.

Hmmm...possible issue: a Text field is limited to 255 bytes. If your
text is longer you'll need a Memo field instead.