title: MS ACCESS Date Validation Rule ( greater than any other data in DB)
body: <p>I'm stuck writing a MS-Access validation rule for date field in a form ([F_Bill_Date]).</p>
  
  <p>This form allows me to create a billing data register and store it in a table called "Bills". </p>
  
  <p>I would like to create a validation rule for the [F_Bill_Date] form field in order to ensure that the data edited in it is greater than any other data stored in the "Bills" table. Something like [F_Bill_Date] > SELECT MAX (Bill_Date) FROM Bills.</p>
  
  <p>As far as I can see on tutorials, I think the rule should be something like:</p>
  
  <blockquote>
    <p>MAX ([Bill_Date]) 
    or
    MAX ([Bills].[Bill_Date])</p>
  </blockquote>
  
  <p>but none of them works.</p>
  
  <p>Any advice?</p>
  
  <p>Thanks</p>