title: select random row from MS access table
body: <p>i want display 1 record from colums <code>zodys</code>, I'm programint in C# </p>
  
  <p>I have table <code>test</code> and I want select row <code>zodys</code></p>
  
  <pre><code>SELECT top 1 zodys from test ORDER BY rnd(zodys)
  </code></pre>
  
  <p>I get error: <code>Data type mismatch in criteria expression.</code> </p>