Results 1 to 3 of 3
  1. #1

    Saving Append Query Validation Errors (Access 2000)

    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!

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    SC, USA
    Thanked 0 Times in 0 Posts

    Re: Saving Append Query Validation Errors (Access 2000)

    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>

  3. #3

    Re: Saving Append Query Validation Errors (Access 2000)

    Thanks! I should have seen that.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts