Access - Validation Start/End Times

[Pendelfin]

Please can somone let me know what the validation rule should be in the End
Time field to ensure that this number is after the Start Time.

 

[Pendelfin]

Sorry to be a little slow here, but how would I amnd this for Times. I am
new to access so am trying to teach myself.

Many Thanks

Please can somone let me know what the validation rule should be in
the End Time field to ensure that this number is after the Start Time.

The validation rule for both controls would be...

DateValue(Nz([Start Date],"1000-01-01"))<DateValue(Nz([End Date],"3000-01-01"))
Or Is Null

The Nz()s allow for the fileds top be null (required since you must fill out one
first). The DateValue functions would not be necessary if the controls are
bound to DateTime fields, but might be if the controls are unbound.

 

[Rick Brandt]

In Access when you enter "only times" you are actually entering a
DateTime where the date is assumed to be 12/30/1899. Since the dummy
date I used for the Nz() expression for the Start Date is prior to
12/30/1899 that same expression should work for times as well.

I was mistaken above. Since I used DateValue() any time component is stripped
off. For times one would either change both DateValue() functions to
TimeValue() or one could use CDate() instead which would work for any
combination of dates-only, times-only or when both date and time are used
together.