Weird validation rule error

[UniqueTII]

I have two tables with identical fields and I have an append query which takes all info from table1 and archives it to table2 before table one is deleted. The problem is that I am getting validation rule errors on 15 of the records, which I don't understand, because table2 is just a copy of table1 without any info. Anyone have any ideas?

 

[Jack Cowley]

I would not do what you are doing. What I would do instead is add a Yes/No field to your table and call it Archived. When a record is no longer needed check the Archived field and you are good to go. Queries will show you Active or Archived records as you need them.

hth,
Jack

 

[UniqueTII]

I suppose I could do things that way...I need to output the table to a text file, though. Is there a way to do that without exporting the "archived" records?

 

[Jack Cowley]

Base your Export specifications on a query that has filtered the data.... From Access Help, "You can export the data in Microsoft Access select queries to text files. Microsoft Access exports the result set of the query, treating it just like a table."

hth,
Jack

 

[UniqueTII]

I found the error...it was a field with 15 blank records...thanks for the help, though.