Link to home
Start Free TrialLog in
Avatar of cookiejar
cookiejarFlag for United States of America

asked on

MS ACCESS 2010 VBA loop through multiple recordsets and update a recordset with a value

Could you give me an example on how to set and loop through multiple recordset

Set  Recordset1 = Select Statement

Loop through Recordset1
    set Recordset2 = Select from table where column = Recordset1.column
    Loop through RecordSet2
       concatenate Recordset2.column into hold_variable
         hold_variable  =hold_variable+ "," +  RecordSet2.column
    End loop
    'How do I set up a recordset to update a value in a table?
    Update a column in table with hold_variable
 End loop
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial