S
Serena
Hi
Using Access 97
1) I have a table with (amongst others) two fields, Status
and Action. How can I set the validation on the Action
field so that it is not allowed to be Null if the Status
field is "Actioned" ?
2) I have a reference table which has From and To date
fields. Is there any easy way (i.e. no VB) of checking
that none of the records overlap i.e. no From or To date
falls between the range of the From and To dates on any
other record ? (I have managed to set the validation to
ensure the To date > than the From date on a given
record !)
TIA
Serena
Using Access 97
1) I have a table with (amongst others) two fields, Status
and Action. How can I set the validation on the Action
field so that it is not allowed to be Null if the Status
field is "Actioned" ?
2) I have a reference table which has From and To date
fields. Is there any easy way (i.e. no VB) of checking
that none of the records overlap i.e. no From or To date
falls between the range of the From and To dates on any
other record ? (I have managed to set the validation to
ensure the To date > than the From date on a given
record !)
TIA
Serena