Hi
In the following code W1 = Week 1, W2 = Week 2 and so on. I am trying to write a loop to refer to W1 (access field) as a variable e.g "W" & i; i being 1 to 10 (weeks in a school term). I have had a good look around and can;t seem to find how to do this. All the other references work fine...