Check for specific pattern right of decimal point

[merebag]

I need a way to verify and trap for any value that is not in a quarter hour increment for an hours field. In other words, when a user enters in some hours for a billing program, I want only whole hours plus any quarter hour increments only. Example: (1.25 is good, 1.30 is not good) (23.75 is good, 23.80 is not good). Any good logic to trap for that in either using access commands or vba commands?



Thanks

Jeff

[pbaldy]

Check out the Mod operator. I don't think it will use the fractions, so multiply by 100 and use 25 instead of .25.

[merebag]

That's a good approach. I will try that. Thanks

[pbaldy]

No problem, post back if you get stuck.