Query Truncates Field Data

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a table with two memo type fields in them.

When I use a query to bring in those fields it truncates
them to 255 characters.

I'm using access 2000.

Any help would be greatly appreciated.
 
I have a table with two memo type fields in them.

When I use a query to bring in those fields it truncates
them to 255 characters.

I'm using access 2000.

Any help would be greatly appreciated.
Click to expand...

Any SORT, GROUP BY, or various functions will truncate a Memo. Could
you perhaps post the SQL of the query?
 
This is a query news group so it is often recommended that you should post
your sql view. I expect you have phrases like "DISTINCTROW", "DISTINCT",
"GROUP BY" or "UNION" in your sql.
 
I was unnecessarily using Group By in the query, removing
them did correct the problem.

For future reference is there a fix for this if I need to
use grouping and a large memo field together?

Tom
 
I think you can use FIRST or LAST for the memo field as long as you don't care
which memo of the group is returned. If you really need to get "Group" by the
memo field, you can try breaking it into multiple sections of 255 characters
each (or less) and then recombining them when you display the information on a
form or report.
 
Back
Top