I am not sure what you want... but lemme try
> open recordset with dbOpenDynaset flag
> rst.movefirst
> if rst!Quantity <condition> then rst!Quantity <Value>
> rst.movenext
> loop until the record pointer reaches the end of file (depending on the record count in the recordset with the sql statement)
(if this is not then put up still in clear words, so i can understand)
Hope this helps.
With Regards,
Raghavendra Mudugal
|