title: Access Validation Error?
body: <p>Hi all I'm creating a database in Microsoft Access 2007 that involves the Date Of Birth and Age of the customer in one particular form. I have already managed to use a validation rule that restricts and age limit so the customer must be 17 or over; but i also need to calculate age from the DOB and when using this piece of validation <a href="http://office.microsoft.com/en-us/access-help/calculating-age-from-a-birth-date-in-access-HA001055071.aspx" rel="nofollow">http://office.microsoft.com/en-us/access-help/calculating-age-from-a-birth-date-in-access-HA001055071.aspx</a> if gives me the error: "SQL Syntax coloumn error" or something along them lines. I think it could be the two pieces of code interfereing with each other. When i get back to my computer with access installed i will post the exact error and other piece of validation.</p>
  
  <p>Can anyone help me? </p>
  
  <hr>
  
  <p>Here is the validation in the DOB field:</p>
  
  <pre><code> &lt;=DateSerial(Year(Date())-17,Month(Date()),Day(Date()))
  </code></pre>
  
  <p>and here is the validation i am trying to put into the Age field:</p>
  
  <pre><code>=DateDiff("yyyy", [DOB], Now())+ Int( Format(now(), "mmdd") &lt; Format( [DOB], "mmdd") )
  </code></pre>
  
  <p>And this is the error i am recieving:</p>
  
  <pre><code>"Invalid SQL Syntax - cannot use multiple coloumns in a coloumn-level CHECK constraint"
  </code></pre>
  
  <p>Anyideas?</p>