Moving records between tables in MS Access

  1. adjacent

    adjacent 1,533
    Gold Member

    I have two tables(a and b) in one access document. And in each table, I have a field[called status](look up field) having the options "Done" and "Done_s".
    What I want to do is move the records having the [status] "Done_s" to b. This should be done whenever the change occurs. Is this possible?

    I never used access before and google also does not provide an answer to this.
     
  2. jcsd
Know someone interested in this topic? Share a link to this question via email, Google+, Twitter, or Facebook

Have something to add?

0
Draft saved Draft deleted
Similar discussions for: Moving records between tables in MS Access
Loading...