Diary Schedule Insert

[pbeeke]

Does anyone know how I could take a weeks entries in a table and copy and insert the same entries into the same table but with the starting date a week on.
class_id class_dte class_start_tim e class_end_time class_name class_def_id
6 21/11/2007 13:25 19/11/2007 11:00 19/11/2007 12:00 Spanish 1
8 21/11/2007 14:44 19/11/2007 12:00 19/11/2007 13:00 French 1
9 21/11/2007 14:48 19/11/2007 16:30 19/11/2007 17:30 Maths 3
10 21/11/2007 15:49 19/11/2007 17:30 19/11/2007 18:30 English 1
11 21/11/2007 15:55 20/11/2007 11:00 20/11/2007 12:00 English Literature 5
12 21/11/2007 15:56 20/11/2007 12:00 20/11/2007 13:00 Metalwork 5
13 21/11/2007 15:57 19/11/2007 18:30 19/11/2007 19:30 Metalwork 5
14 21/11/2007 15:58 20/11/2007 16:30 20/11/2007 17:30 English 9
15 21/11/2007 15:59 20/11/2007 17:30 20/11/2007 18:30 Spanish 9
16 21/11/2007 15:59 20/11/2007 18:30 20/11/2007 19:30 Spanish 12
17 21/11/2007 15:59 21/11/2007 11:00 21/11/2007 12:00 Art 12
18 21/11/2007 15:59 21/11/2007 12:00 21/11/2007 13:00 Art 11
19 21/11/2007 15:59 21/11/2007 16:30 21/11/2007 17:30 Woodwork 11
20 21/11/2007 16:00 21/11/2007 17:30 21/11/2007 18:30 Woodwork 14
21 21/11/2007 16:00 21/11/2007 18:30 21/11/2007 19:30 French 14
22 21/11/2007 16:00 22/11/2007 11:00 22/11/2007 12:00 French 14
So that I could make a carbon copy of one weeks lessons and move them on a week.

Thanks in advance