I'm trying to make an update to record set and update field names day01, day02, day03, day04...

I would like to perform this update by a for loop and then use recordsetname.day & itr = value... for the each iteration of the for loop...

kind of like this...

for i = 1 to countdays
recordset.edit
recordset.day & i = value 'help here
recordset.update
next i

Can anyone help with this pitiful mess?

Thanks,
Marc