Gustav Brock
Gustav at cactus.dk
Sat Oct 22 04:52:04 CDT 2005
Hi Jim and Scott With all respect, in my opinion this is not the route to follow. Machines should help people (users) not bother them. Thus the rounding solution as suggested by Ken is what you should (and I do) use. Perhaps associated by a Beep when rounding occurs ... /gustav >>> Jim.Hale at FleetPride.com 21-10-2005 22:04:57 >>> cool. That one goes in the goody bag Jim Hale -----Original Message----- From: Gina Hoopes [mailto:hoopesg at hotmail.com] Sent: Friday, October 21, 2005 2:18 PM To: AccessD at databaseadvisors.com Subject: Re: [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