Results 1 to 3 of 3
  1. #1
    pinklady is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2013
    Posts
    2

    If I enter data into one field, I want it to move the whole row to a new table

    I'm not sure if I can do this in Access or not, but what I have are 2 tables in Access, Ongoing and Closed. I have a lot of columns in each table, the two that are specific to this are Date Opened and Date Closed.

    What I want is if I enter a date in the Ongoing table in column Date Closed, that it moves the whole row of information to the Closed table.



    Is that possible? Thank you for your help!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    It's possible but don't recommend it. Just use the DateClosed field to filter records to show only the ongoing.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    pinklady is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2013
    Posts
    2
    Ok. Thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Code to move data from table to another
    By zachlunch in forum Programming
    Replies: 1
    Last Post: 08-30-2013, 12:12 PM
  2. Move query data to a new table using VBA
    By Bob Blooms in forum Programming
    Replies: 1
    Last Post: 09-23-2012, 08:33 PM
  3. Replies: 4
    Last Post: 02-27-2012, 10:29 AM
  4. Enter Data into a Junction Table
    By darkwan75 in forum Database Design
    Replies: 3
    Last Post: 04-13-2011, 08:55 PM
  5. Move data from one table to another
    By rebyrd in forum Queries
    Replies: 2
    Last Post: 12-24-2009, 12:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums