Member Avatar for APRIL425
APRIL425 0 Newbie Poster

I am using Access 2007 to try and calcualate the difference between two time fields and when I enter in the validation rule I receive the following error!

I do not have the field indexed.

"Invalid SQL syntax error - cannot use multiple columns in a column-level CHECK constraint"

Can someone help me with this?:'(

  • 1 Contributor
  • 0 Replies
  • 70 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.