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

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).