null validation rule

G

Guest

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.
 

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

Access Validation rule of 1 field based on a field of another table 1
Validation rules - digits & letters only 1
Validation Rule 2
validation rule for exactly 5 digits, including leading zeros 0
Validation Rule for maximum length 6
validation rule (for a record in a table) with dlookup 7
Validation Rule 7
Validation Rule On Form 2

Top