I'm very stuck now.
I want to introduce a rota system into my database that is currently done by spreadsheet.
The current rotas are broken down by teams. In the team there can be up to 20 different rota patterns. One name is assigned to one rota pattern each week, so there will be 20 names one against each rota. Everyweek the employees move down the list and move to the next rota pattern in the list.

For example.
Week1
Rota 1 - Employee 1
Rota 2 - Employee 2
Rota 3 - Employee 3
Rota 4 - Employee 4
Rota 5 - Employee 5

Week 2
Rota 1 - Employee 5
Rota 2 - Employee 1
Rota 3 - Employee 2
Rota 4 - Employee 3
Rota 5 - Employee 4

How can I do this so I don't have to go into the database every week and move people around. In other words I want the employees to move to the correct rota automatically every week.

You would need to create a function that will evaluate the current rota the employee is one and then update it to the new one. I would think you will need to do this via a recordset and loop through. If you could post your db in A97 format, I'd be happy to take a look and see how you can employee this.

HTH.