I have a field (control) for hours worked and need to be able to limit it to 1/4, 1/2 and 3/4 hour increments. For example 8.0, 8.25 (for 15 minutes, which some users can't figure out and still put .15), 8.5 or 8.75 are accepted, but 8.15 is not.....I thought about an If statement but 7.25, 7.5 etc is also acceptable. How to I set validation for the decimal portion of the number only, or is it not possible?
Thanks in advance for any and all help.
----
Access 2002 on a mixed Windows OS network.
Thanks in advance for any and all help.
----
Access 2002 on a mixed Windows OS network.