Member Avatar for Robshaw236

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

  • 3 Contributors
  • 3 Replies
  • 979 Views
  • 9 Years Discussion Span
  • Latest Post Latest Post by jonobugs
Member Avatar for Robshaw236

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

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

Member Avatar for dgallanger

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

Member Avatar for jonobugs

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.