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

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!
 
D

Douglas J. Steele

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.
 

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

text box in report is 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
conditional format truncates memo field 1
Memo field truncating in report 3
Memo Field is truncating to 255 Chars 6
Memo field is truncating in group heading of an Access 2007 report 3
Report truncating MEMO column 1
Memo Field Truncating in Word 3

Top