[AccessD] Quarter hour increments

Works perfectly! Thanks, Scott!

Gina

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Scott Marcus
Sent: Friday, October 21, 2005 1:20 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Quarter hour increments

In the table, use the Validation Rule and Validation Text like the 
following...

Validation Rule - ([name of your field]*100) Mod 25 = 0 Validation Text - 
The decimal portion of the time entered must be 0, 25, 50, or 75!

Hope that helps...

Scott Marcus
IT Programmer
TSS Technologies Inc.
www.tss.com