Field being truncated - memo field

if you wish to see the sql of the Duplicates_Removed qry:

SELECT First(Import_Excel.ID) AS OneID, Import_Excel.Deliverable, Import_Excel.Frequency, Import_Excel.[Section Referenced], Import_Excel.Timing, Import_Excel.[End or Start Date comments], Import_Excel.Agreement, Import_Excel.Comments, Import_Excel.[Area of Responsibility], Import_Excel.Description, Import_Excel.Receivor
FROM Import_Excel
GROUP BY Import_Excel.Deliverable, Import_Excel.Frequency, Import_Excel.[Section Referenced], Import_Excel.Timing, Import_Excel.[End or Start Date comments], Import_Excel.Agreement, Import_Excel.Comments, Import_Excel.[Area of Responsibility], Import_Excel.Description, Import_Excel.Receivor;

Read this for the 6 most common reasons http://allenbrowne.com/ser-63.html

Well-known issue.
You can use the technique here:

https://www.experts-exchange.com/questions/28554757/Access-Query-truncates-Memo-Field.html?anchorAnswerId=40434530#a40434530

/gustav

OK I see it is an issue with Access and not me.  For once I am not wrong!  Wow!  I only spent 1 hour figuring that out.  

Gustav, I see you have provided a work around.  

Macroshadow:  I don't see a solution though.

Gustav:  how would I call that function?  I read your post in the other question and I will create a new module etc etc.  

thank you

Look in the workarounds column.

Hi GUSTAV, thank you very much.  I will try it and hopefully it only looks more difficult that it is...

Have a good day

Thanks! You will manage, I'm sure.

/gustav