Validation Rule

  • Thread starter Thread starter Tausif
  • Start date Start date
T

Tausif

Hi All GURUS,
I have a table name CustomerSystem where I have stored Purchase_Date and
Warranty_Expiry dates. I would like to put a validation rule at
Warranty_Expiry i.e. it should be greater then Purchase_Date. I tried
[Purchase_Date] its giving me error Invalid Sql Syntax - Cant use multiple
Click to expand...
columns at column level CHECK constraint.

How to define such validation rule?

Tausif
 
Try to create Validation rule at table level but not at the field level. Use
following as reference.

http://www.kbalertz.com/209106/Table.Field.Validation.Causes.Error.aspx
Tausif.

Tausif said:
Hi All GURUS,
I have a table name CustomerSystem where I have stored Purchase_Date and
Warranty_Expiry dates. I would like to put a validation rule at
Warranty_Expiry i.e. it should be greater then Purchase_Date. I tried
[Purchase_Date] its giving me error Invalid Sql Syntax - Cant use
Click to expand...
multiple
columns at column level CHECK constraint.

How to define such validation rule?

Tausif
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule 1
table validation 3
multiple validation rules 3
Validation Rule 2
validation rule invalid? 1
Set validation rule for many fields with vba? 7
Validation Rule in Table 2
exit sub on validation rule violation 4

Back
Top