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


    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


    User Avatar
    Gold Member

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook