null validation rule

[icccapital]

I am trying to force the table column to contain a number and not be null
because in a report I was testing for =0 or >0, but it wasn't working because
when the value was left blank only a test for null would work. So I tried to
add a validation rule that said not(isnull([table column])), but it only gave
me the error when I entered 0. What is the best way to make sure that the
table definitely gets a number either 0 or larger?

ps i also tried =0 or >0 in the table validation rule, but it allowed me to
leave the field blank. Thanks for the help.

 

[Lynn Trapp]

Set your column validation to >0 And Is Not Null