Validation of time

[Guest]

I need a validation rule to assure that Start_Time is before End_Time.

 

[Guest]

Where do you intend to put this rule?
What format are the times in?

 

[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])