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:
dim intcounter as integer do while rssstorage.eof = false intcounter = intcounter + 1 fieldnames = "SD" & intcounter RsStorage.Fields(fieldnames) = Date 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




Reply With Quote