Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2010
    Posts
    32

    Unanswered: Move then Remove in query

    Hello all (again),

    I've created a MakeTable query in which if a record is 'Yes' then the record moves into a new table. I was wondering if someone could show me how I could also remove the record from the table it is in and also for the query to, instead of creating a new table everytime, update the table the record is being inerted into?

    Cheers

  2. #2
    Join Date
    Jul 2010
    Posts
    32
    Or is there a simpler way?

  3. #3
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I'll say again that having two tables is almost certainly a mistake. In any case, you'd want an append query rather than a make table query, and then you'd run a delete query.
    Paul

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    effectively this is a continuation of:
    http://www.dbforums.com/microsoft-ac...in-tables.html
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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