ensure one field is less than the other

[y2k1981]

Hi All,

in an access table, how can I write a validation rule so that the value entered in Field_X is less than what was entered in Field_A in the same table? I've tried <=[Field_X]. I've tried it without the square brackets, but accees puts them back in, which is leading me to beleive I'm not far off the mark, but still I can't get it right, any help at all?

 

[JimHorton]

[Field_x]<[Field_A]

This should be in the Table-level properties, not the fields.
--jim

 

[y2k1981]

cool, thanks, workds a treat. but why did it have to go into the table properties, why couldn't I put it in the field properties for field_X?

 

[JimHorton]

Because Jet can't 'see' another field in one field's validation rule, but at the table-level it sees all fields.
-jim