[AccessD] Simple record-level validation rule

Steve Schapel steve at datamanagementsolutions.biz
Mon Jan 16 16:52:19 CST 2012


Hi Susan

Does this do what you want?
[overtime]=0 Or [hours worked]>40

Regards
Steve

-----Original Message----- 
From: Susan Harkins
Sent: Tuesday, January 17, 2012 11:30 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Simple record-level validation rule

I thought I could write a validation rule (table level) that would check 
overtime values. If hours worked is less than 40, overtime must be 0. I 
can't figure it out. Can I do this?

Susan H.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 



More information about the AccessD mailing list