Hi i need a validation rule for MS Access so that only a time can be entered that is between 18:00 and 23:00

The validation rules must allow for the above numbers inclsuively

Please Help

Re: Validation rule required for time PLEASE HELP 80 80

Just to let you know, i have figured it out for myself the validation rule isl

>= #18:00:00# And <= #23:00:00#

Re: Validation rule required for time PLEASE HELP 80 80

thank you for the solution, i found this thread helpful.

Re: Validation rule required for time PLEASE HELP 80 80

Just to let you know, even 9 years later, someone (me) found this post useful! Thanks...

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.