K
Kate
I have 2 fields in a table "completed", which is a checkbox (yes/no) and
"completedDate" (date).
If "completed" is checked Yes then "completedDate" cannot be null and If
"completed" is checked No then "completedDate" can be null.
I'm using Access 2000 (which I haven't used for ages). I have put SQL code
in the Validation Rule for "completedDate",
CHECK([completed]=Yes) and ([completedDate] Is Not Null)
but this doesn't seen to work.
Am I completely wrong or am I putting it in the wrong place??!
TIA
Kate
"completedDate" (date).
If "completed" is checked Yes then "completedDate" cannot be null and If
"completed" is checked No then "completedDate" can be null.
I'm using Access 2000 (which I haven't used for ages). I have put SQL code
in the Validation Rule for "completedDate",
CHECK([completed]=Yes) and ([completedDate] Is Not Null)
but this doesn't seen to work.
Am I completely wrong or am I putting it in the wrong place??!
TIA
Kate