Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Question Unanswered: Append One Record to Another Table

    I really need some help with this one as I am under a time crunch to resolve. I have two tables with the exact same fields, just different data. I want the user to be able to move ONLY ONE record from table A to table B, how can I do this? I have an APPEND QUERY set up but it wants to move all the records over. I would like the user to select the record by its Key or autonumber.

    Need help fast!-- Thank you!

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You have to set the WHERE condition in this Append Query to only copy the required record.

  3. #3
    Join Date
    Nov 2003
    Posts
    300
    Thank you!

Posting Permissions

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