Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Table db Design > conditional val...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 12051 of 12659
Post > Topic >>

conditional validation rules

by =?Utf-8?B?YnVzY2hlcjc1?= <buscher75@[EMAIL PROTECTED] > Jul 28, 2008 at 08:36 AM

I have set a validation rules for a table and also for fields.  Now I need
to 
set another table validation rule to say:
	If field1 = “complete”, then field2 must be greater than zero (it is
a 
numeric field).
	If field1 = “incomplete”, then field 2 can be blank or zero.

I have set a validation rule for field1 to either “complete” or
“incomplete” 
and made it a required field.  I want to make field2 a required field
also.

I am unsure of how to enter this into the table’s validation rule, or
even 
the field2 validation rule.  Do I just start another line and start typing
a 
second rule in VB mode for the table?  Or do I have to identify each 
validation rule?  I hope this makes sense.
 




 6 Posts in Topic:
conditional validation rules
=?Utf-8?B?YnVzY2hlcjc1?=   2008-07-28 08:36:01 
Re: conditional validation rules
"Allen Browne"   2008-07-28 23:52:14 
Re: conditional validation rules
=?Utf-8?B?YnVzY2hlcjc1?=   2008-07-28 10:52:01 
Re: conditional validation rules
=?Utf-8?B?YnVzY2hlcjc1?=   2008-07-28 14:35:16 
Re: conditional validation rules
John W. Vinson/MVP <pl  2008-07-28 17:30:19 
Re: conditional validation rules
=?Utf-8?B?YnVzY2hlcjc1?=   2008-07-29 13:43:02 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 22:11:54 CST 2008.