Hello, I have a query which contains several memo fields. I want to export the results of this query to Excel, but within Access 2007 the memo fields are truncated in the query. How can I change this and make a clean export of the query and data? In the Access query I use a few SQL commands: IN() HAVING() WHERE() and INNER JOIN() as well as merging some text fields. Can anyone offer me any advice?