Results 1 to 2 of 2
  1. #1
    Zafarm is offline Novice
    Windows 8 Access 2007
    Join Date
    Jul 2017
    Posts
    1

    Copy current data and Append

    Need Solution
    copy data 1
    append as Rec 2
    Amend retired date in rec 1


    same date in Acquired date after issuing to dept.
    Attached Thumbnails Attached Thumbnails AccessQry.jpg  

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    create a query that returns the first record
    use that query as the basis for an append query and append the record
    use same first query as the basis for an update query; set the value of Retired Date to whatever the amended value will be. Also set Acquired Date to that value.
    OR
    copy the record(s) to the clipboard
    paste append to the table
    create the update query but use whatever date value is required (this case, it would not reference the first query as you wouldn't need it).

    The info you provided is somewhat sketchy. I'm assuming there'd be no data integrity violations and that you're not using a form, and that there's only one record to copy.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 4
    Last Post: 01-20-2015, 12:55 PM
  2. Copy value of primary key on current record
    By PPCEngineering in forum Programming
    Replies: 6
    Last Post: 07-20-2014, 04:31 AM
  3. Append Query Current Record Only
    By KCC47 in forum Queries
    Replies: 5
    Last Post: 10-25-2013, 02:00 PM
  4. copy and append a record
    By erikl1 in forum Access
    Replies: 4
    Last Post: 03-02-2012, 03:47 AM
  5. Replies: 3
    Last Post: 05-07-2011, 10:25 AM

Tags for this Thread

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