G
Guest
I need a validation rule to assure that Start_Time is before End_Time.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Where do you intend to put this rule?
What format are the times in?
What format are the times in?
A
Allen Browne
1. Open the table that contains these fields in design view.
2. Open the Properties box (View menu).
3. In the Properties box, beside the Validation Rule, enter:
[Start_Time] < [End_Time]
Note that the validation rule in the properties box is for the record (the
rule on the table.) That's not the same as the Validation Rule in the lower
pane, which applies to one field only, and is therefore not suitable for
comparing fields.
In some versions of Access, you need to specifically allow nulls if you need
that, i.e.:
([Start_Time] Is Null) OR ([End_Time] Is Null) OR ([Start_Time] <
[End_Time])
2. Open the Properties box (View menu).
3. In the Properties box, beside the Validation Rule, enter:
[Start_Time] < [End_Time]
Note that the validation rule in the properties box is for the record (the
rule on the table.) That's not the same as the Validation Rule in the lower
pane, which applies to one field only, and is therefore not suitable for
comparing fields.
In some versions of Access, you need to specifically allow nulls if you need
that, i.e.:
([Start_Time] Is Null) OR ([End_Time] Is Null) OR ([Start_Time] <
[End_Time])