Search results

Thanks Steve That worked. Kind Regards Paul

In response to Jdraw's question "In plain English --no jargon and no quasi programming code --what are you trying to accomplish?" I am trying to update an Excel Spreadsheet conditionally based on the content of each Access record. In the Access Data base there are columns W1 - W11 (weeks 1 to...

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