validation rule for time field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a SQL database using Access project files to run forms etc. There is
a field where the user must enter the time. The time must be either :15 or
:45 minutes after the hour. (So it could be 1:45 or 6:15, but not 1:46 or
6:14.) We'd like to set up a validation rule that requires the time be **:14
OR **:45, but we can't figure out how to put that in. Does anyone have an
answer to this?

Your help is appreciated!
 
Try this --
Format([YourFieldName],"nn")=45 Or Format([YourFieldName],"nn")=15

Then type in a validation rule message.
 
Back
Top