update query w some fields null

[Ted]

Hi all,

I'm running an update query to update about 7 fields in my table. Whenever I
try to run the query i get "Microsoft Access didn't update 30 records due to
validation rules violations." I'm sure its bc some of the values that are
updating are null. They aren't required fields in the table tho. How do I
get around this?

TIA
Ted

 

[louisjohnphillips]

Hi all,

I'm running an update query to update about 7 fields in my table. WheneverI
try to run the query i get "Microsoft Access didn't update 30 records due to
validation rules violations." I'm sure its bc some of the values that are
updating are null. They aren't required fields in the table tho. How do I
get around this?

TIA
Ted

Look a little deeper into what is causing the message. "Validation
rules violations"
occur when an update query attempts to violate a column constraint.

Perhaps a date/time column is constrained to only dates in the past;
or an integer
column is constrained to only positive numbers.

A NOT NULL constraint would be violated if the query explicitly said

UPDATE table1 SET field1 = NULL

or

UPDATE table1 SET field1 = field2 and field2 happens to be NULL