help with append query

[scottk]

I am having difficulty appending records to my tables becaue of validation rule errors. I have recieved a complete list of newspapers, radio stations and television stations for my state from another company. The list was originally in an excel spreadsheet so I imported it as a new table. I then made an append query to add these records to my main table. However, I am unable to append the records because I recieve a validation rule error. After some experimentation I concluded that the source of the proplem is that fields in some of the records in the new table are empty and the query will not let me paste the record in. My problem is that these fields are supposed to be empty. If the company does not have a fax machine, the Fax Number field should be empty. How can I get around this validation rule error without having to place something in the fields that should be empty?

 

[pdx_man]

remove/re-write the validation rule. It will be under the properties in the design view of the table.

 

[scottk]

That did it. Thank you Pat.