On my table i have fields like

WorkerID
Course1
SD1 (startDate1)
ED1 (enddate1)
Course2
SD2
ED2

all the way to 15.


Now I want to store certain dates into this..so I have been trying to enter the data into the fields with this


VB Code:
  1. dim intcounter as integer
  2. do while rssstorage.eof = false
  3.       intcounter = intcounter + 1
  4.       fieldnames = "SD" & intcounter
  5.       RsStorage.Fields(fieldnames) = Date
  6. loop

But that doesnt work...For the record thats not a copy, i just wrote it out now..but its basically what i am trying to do