Hello,
I'm a novice at microsoft access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal point. An axample is for an 8 hour day you would have to enter 08.00. I set it up to limit it to 24 hours by putting <24 in the validation rule box, too. The real problem is I need for the time to be entered in 1/4 hour increments, such as, 6.00, 5.25, 8.50 or 7.75. I've tried a few different ways but nothing is working. I could please use anybodies help with this.
Thanks,
Dan