**I have been automatically collecting machine breakdown info to a database for 12 months, so I have thousands of entries in a 'Machine Downtime' table.
However, I have found that the time_down column is offset by one row. The 'time_down' in the top row needs to be moved to the second row, time_down in the second row moved to the third etc...
Timestamp | Reason | time_down
2012-05-10 10:15:14 | Line Jam | 00:10:00
2012-05-10 10:16:22 | Lunch Break | 00:02:44
There are no other columns in the table, the index is 'timestamp'
Is there an update query that I can use to move all rows automatically?