validation rule for time field

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!
 
G

Guest

Try this --
Format([YourFieldName],"nn")=45 Or Format([YourFieldName],"nn")=15

Then type in a validation rule message.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top