get and remove records form recordset

[xopherira]

I am trying to update a record set. I need to be able to grab first three records from array and process with update query then get rid of and process next three until end of array. Have tried multiple for loop variation with no success. Below is a print of array.

15 records retrieved.
  Material- S30007, Serial Number- DAJ0484, Parent SN EFDAH3224
  Material- S30000, Serial Number- DAJ2379, Parent SN EFDAH3224
  Material- S30146, Serial Number- DAJ3535, Parent SN EFDAH3224
  Material- S30007, Serial Number- DAJ0491, Parent SN EFDAH3225
  Material- S30000, Serial Number- DAJ2377, Parent SN EFDAH3225
  Material- S30146, Serial Number- DAJ3539, Parent SN EFDAH3225
  Material- S30007, Serial Number- DAJ0477, Parent SN EFDAH3226
  Material- S30000, Serial Number- DAJ2396, Parent SN EFDAH3226
  Material- S30146, Serial Number- DAJ3532, Parent SN EFDAH3226
  Material- S30007, Serial Number- DAJ0480, Parent SN EFDAH3227
  Material- S30000, Serial Number- DAJ2400, Parent SN EFDAH3227
  Material- S30146, Serial Number- DAJ3541, Parent SN EFDAH3227
  Material- S30007, Serial Number- DAJ0482, Parent SN EFDAH3228
  Material- S30000, Serial Number- DAJ2397, Parent SN EFDAH3228
  Material- S30146, Serial Number- DAJ3537, Parent SN EFDAH3228

[June7]

Why 3 at a time? You need to somehow aggregate 3 records into 1? Why using code and not query?

Describe what you are really trying to accomplish. Post your attempted code.

[xopherira]

Is it possible to delete records from recordset while processing it. Yes need to aggregate, and using code due to nature of tool and limitations.

[June7]

No, don't delete from recordset. Skip them or don't retrieve to begin with - apply filter. What 'nature of tool' and 'limitations'? Still don't understand what you want to accomplish.

[orange]

Seems SN is related in hierarchy

Parent SN--->Serial Number
and adding 3 common materials to each Serial Number

[June7]

So why not an aggregate (Totals) Group By query? What aggregation do you want - Sum, Avg, Count?

Why not a report using Sorting & Grouping features with aggregate calcs in group footer section?

Or do you want something like http://allenbrowne.com/func-concat.html

[orange]

It might be clearer if poster explained this in plain English

grab first three records from array and process with update query then get rid
of and process next three until end of array.