validation rules

[stressed]

how do i create a validation rule - e.g in the case of where the appointment
date has got to be after todays date, with fields AppointmentDate and
TodaysDate.
i have tried to create it as: AppointmentDate >= TodaysDate but it soes not
work
what am i doing wrong?

 

[Ofer]

are you trying to run your validation in a form?

 

[stressed]

no in design view for a table

are you trying to run your validation in a form?

 

[Ofer]

goto to the help on that metter.
it says that :
In addition, field validation rules can't contain references to other fields

 

[Ofer]

Sorry
You can do that with the validation rules for the table, but not with the
validation rules of the field.

 

[Van T. Dinh]

In the Validation Rule of the Field, use:

Date()

Enter appropriate message for the Validation Text.

HTH
Van T. Dinh
MVP (Access)