Saving Append Query Validation Errors (Access 2000)

[kvrkat]

Hi Folks,

I would like to save the records that fail the validation rules in an append query to a seporate table. (Similiar to the "paste errors" table)

I'm sure that it's simple, but I can't find any info on how to to do it.

Thanks for your help!

[willyboy]

Your validation rules cause your query to select records that pass the validation. Create a second query, similar to the first, except that now you want to re-word the validation to select records that would be rejected by the first query. In other words, if the first query only selected records where a particular field was less than 1000(this is just an example), then let the second query select records equal to or greater than 1000. Make this an append query to a new table(either design this new table yourself, or you can run a make table query one time(based on the second query) to create the new table. Now simply set up your database to always run both queries, instead of just your original query. <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

[kvrkat]

Thanks! I should have seen that.

Kat