Access Query Hangs w/ Where instead of Join on Memo field <p>Access 2013</p> <pre><code>UPDATE [1 Clean Reasons], Data, [Final Crosswalk] SET [Final Crosswalk].CR_ID = [1 Clean Reasons].[CR_ID] WHERE (((Data.Reason)=[1 Clean Reasons].[Reason])); </code></pre> <p>I'm trying to build a record ID crosswalk table, "Final Crosswalk", I need to join Data.Reason = 1 Clean Reasons.Reason, but it's a memo field - thus the Where statement.</p> <p>I can view this query, but I can't get it to export or update. I'm assuming it's an issue with the resource requirements of the Where statement (the table has ~1M records).</p>