DISTINCT in code truncates a memo field to a text (255 characters)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I won't go into the agonizing, but I think in the process of working
through our project we have found a bug with Access.

Basically, I have created a report based on a table, which has links to
other tables, when run the report duplicates some records and I am not sure
why. When I include the Distinct statement to eliminate the redundancy (which
it does), the included memo field is truncated (not the data in the table,
but the view in the report).

If anyone has any ideas as to why this select criteria would do this. Or,
even better, a reasonable explanation for why a report would be duplicating
records from a table I will appreciate it!
 
That's by design. Anytime you're trying to guarantee uniqueness (SELECT
DISTINCT, UNION or GROUP BY, for instance), Access only looks at the first
255 characters of Memo fields, since looking at the whole memo field might
be a very time consuming task.
 
Back
Top