title: How can get the last value of column
body: <p>How can I retrieve the last entered value of the column in the database (MS ACCESS 2007)</p>
  
  <p>I used the following code</p>
  
  <pre><code>String sql = "SELECT Last(RegNumber) FROM Death ";
  </code></pre>
  
  <p>but it does not work in MS ACCESS and when I run the program Error generates as</p>
  
  <pre><code>java.sql.SQLException: Column not found
  </code></pre>
  
  <p>but I have created a column in database as <code>RegNumber</code></p>
  
  <p>I am using Java for programming in which I used this query</p>
  
  <p>EDIT:</p>
  
  <p>RegNumber is in  String form not in integer form so I cant use DESC or ASC</p>
  
  <p>Please help me</p>