title: How to convert access memo field to text field in access query?
body: <p>I found this:</p>
  
  <pre><code>SELECT [PartsInfoRaw].[Types] as memofield, Replace([PartsInfoRaw].[Types],"","") AS textfield
  into newTable FROM [PartsInfoRaw];
  </code></pre>
  
  <p>where Types is a memofield in PartsInfoRaw containing some description. The replace, for some reason, converts the memofield in a textfield. But it feels hacky, and I am not sure if it can
  turn sour. Does anyone have a better idea?</p>