Hi,
I have a bit of knowledge on Access, although I still use the 2003 version of the software.
I have just built up a database and I have a question about validation rules on Forms.
I have four dates on my form:
Proposed Date
Scheduled Date
Approval Date
Rejection Date.
I would like to build up a validation rule among these fields. Access allows me to create this in the Proposed Date field property table:
Validation rule: [Proposed Date] < [Scheduled Date]
I can also create [Schedule Date] < [Approval Date], but in both cases I need to fill out the Scheduled Date field at first, which doesn't come in a logical order on the form.
My aim to build up a chronological validation rule among three dates. I also would like to avoid that somebody types a date in both Approval and Rejection Date field on the same record.
Is there anybody who has any suggestion?
Many thanks,
Susanna
I have a bit of knowledge on Access, although I still use the 2003 version of the software.
I have just built up a database and I have a question about validation rules on Forms.
I have four dates on my form:
Proposed Date
Scheduled Date
Approval Date
Rejection Date.
I would like to build up a validation rule among these fields. Access allows me to create this in the Proposed Date field property table:
Validation rule: [Proposed Date] < [Scheduled Date]
I can also create [Schedule Date] < [Approval Date], but in both cases I need to fill out the Scheduled Date field at first, which doesn't come in a logical order on the form.
My aim to build up a chronological validation rule among three dates. I also would like to avoid that somebody types a date in both Approval and Rejection Date field on the same record.
Is there anybody who has any suggestion?
Many thanks,
Susanna