How to loop through all records in the table?

polina

Registered User.
Local time
Today, 12:02
Joined
Aug 21, 2002
Messages
100
Hi,

I need to loop through all records in the table in order to assign the value to the field

Please suggest the code

Thanks
 
something like this:

set Recordset = Database.OpenRecordset("Table")
With Recordset
While not .EOF
'Carry out operations
.Movenext
wend
end with
 

Users who are viewing this thread

Back
Top Bottom