to prefix, I am incredibly new to VBA (around 1 month on/off experience). I managed to write some code to aggregate lines in an array based on certain conditions, which would then be implemented into some code in an access database. Much to my demise, when trying to implement, I quickly learned that Excel VBA and Access VBA do not work the same way, and I am having trouble trying to replace the array reference with a recordset reference. Any help would be appreciated.