Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Moving records between tables in MS Access

  1. Jul 7, 2014 #1

    adjacent

    User Avatar
    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
  3. Jul 8, 2014 #2
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted



Similar Discussions: Moving records between tables in MS Access
  1. Recording sounds (Replies: 2)

  2. Recording a webcam (Replies: 2)

  3. MS Access (Replies: 2)

Loading...