I'm having difficulty and don't know what to do
I have a field called Date Out and a field called Date Returned.
Validation in Date Returned is [Date Returned]>[Date Out] but it's not working!!
Message is
Data Integrity rules have been changed, existing data may not be valid for new rules (well that's obvious) We click Yes and then
Invalid Syntax says cannot use multiple columns in a column level check constraint.
I understand what this is saying but I don't know what to do now to make sure that the date returned is after the date out.
Many thanks for any help
J
I have a field called Date Out and a field called Date Returned.
Validation in Date Returned is [Date Returned]>[Date Out] but it's not working!!
Message is
Data Integrity rules have been changed, existing data may not be valid for new rules (well that's obvious) We click Yes and then
Invalid Syntax says cannot use multiple columns in a column level check constraint.
I understand what this is saying but I don't know what to do now to make sure that the date returned is after the date out.
Many thanks for any help
J