Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    7

    Unanswered: Update Query: Copy field based on the previous week

    Hi,

    I have a student database, with class records based on week numbers. I can assign students to their classes for each week of the year.

    I am now trying to run an update query which will copy the previous week's classes. I.e: For a particular week, i want it to look at the previous week and copy the class number for each matching Student ID.

    Can anyone help!

    Thanks

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by sidbrown View Post
    I am now trying to run an update query which will copy the previous week's classes. I.e: For a particular week, i want it to look at the previous week and copy the class number for each matching Student ID.
    If you want to copy (i.e. create new records from existing ones), it's an INSERT query, not an UPDATE.

    Please provide information about the table(s) involved (name, columns names, data type).
    Have a nice day!

Posting Permissions

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