Query truncating memo fields

[AccessNut]

This is the query I'm using:

SELECT DISTINCT t_Table1.[AssetNumber], t_Table1.DESCRIPTION
FROM q_Query1 INNER JOIN t_Table1 ON q_Query1.[AssetNumber] = t_Table1.[AssetNumber];

q_Query1 is a query which only returns AssetNumbers.

The [DESCRIPTION] field in t_Table1 is a memo field. It contains text, and linebreaks.

The query result truncates the description.


I can't figure out what's wrong. Thanks for your help.

 

[AccessNut]

OK, there must be a bug in Access. I rewrote the query exactly as before and now it is not truncating anymore. Don't know what to make of it.