I have attached my code for review.
The problem I am experiencing is when the query is exported to an Excel Spreadsheet, the Memo field in the query contains weird characters mixed in the text, i.e.:
<div><font face=Arial size=2>E&C received a question from HR about
What is causing this, and how can it be avoided?
I am using MS Access and Excel 2007.