Table syntax

[legalmechman]

I am trying to set up a table in Access 2003. I want to make a field validation rule that forces that field to be greater than 10+ a previous field (currency). I put in '>"field_1"+10' but MS Access says that it's incorrect or too complicated. What am I doing wrong?

[missinglinq]

Access is very strange in how this has to be handled! You can't refer to one field in the criteria for another field, as you've found out. What you have to do is, from Design View for the table, right click, then click on Properties, then in the Validation Rule for the table, enter

[Field_2]>[Field_1]+10

where Field_2 is the criteria field. you're applying the criteria to.

Welcome to Bytes!

Linq ;0)>

[legalmechman]

Access is very strange in how this has to be handled! You can't refer to one field in the criteria for another field, as you've found out. What you have to do is, from Design View for the table, right click, then click on Properties, then in the Criteria Property for the table, enter

[Field_2]>[Field_1]+10

where Field_2 is the criteria field. you're applying the criteria to.

Welcome to Bytes!

Linq ;0)>

First, thank you for such a rapid reply!
Second, I did as you said, but there was no "Criteria Properties" there. A search of the Help screens said that that was a query property. Am I missing something? Are you referring to a later versio of access? (I am on 2003).

Thank you again!

[missinglinq]

My apologies! Follow the above instructions but substitute Validation Rule where I said Criteria Properties! I've edited that post to reflect this; don't want to lead anyone else astray!

Linq ;0)>

[legalmechman]

My apologies! Follow the above instructions but substitute Validation Rule where I said Criteria Properties! I've edited that post to reflect this; don't want to lead anyone else astray!

Linq ;0)>

That seems to have worked! Thank you so very much!

[missinglinq]

Glad we could help!

Linq ;0)>