JerryDi
06-12-2002, 04:44 AM
When appending data from a table to an identical table I get a validation error on some but not all records. Any suggestions ?
Jerry
Jerry
|
View Full Version : Validation error in append query JerryDi 06-12-2002, 04:44 AM When appending data from a table to an identical table I get a validation error on some but not all records. Any suggestions ? Jerry Pat Hartman 06-12-2002, 08:32 AM Check the field properties of the fields in the new table. Your problem is probably caused by the "Allow zero length" property being defaulted to No for some of the text fields. JerryDi 06-12-2002, 08:46 AM Many thanks, it works perfectly now... Jerry:) |