Now I'm trying to figure out how I can push this data into a report.
one way, when you are looping in VBA create a disconnected ado recordset, then when you open the report you assign the recordset to the report
possible code
Code:
dim drst as dao.recordset
dim arst as ado.recordset
Set aRst = CreateObject("ADODB.Recordset")
With aRst
.Fields.Append "NameOfField1", 11 'boolean
.Fields.Append "NameOfField2", 200, 30 ' advarchar
'etc
.CursorLocation = 3 'adUseClient
.LockType = 3 'adLockOptimistic
.cursortype = 3 'adOpenStatic
.Open
end with
set drst=currentdb.openrecordset("whatever you are using now")
while not drst.eof
arst.addnew
arst!NameOfField1=arst!NameOfFieldToAssign
arst!NameOfField2=arst!NameOfAnotherFieldToAssign
'etc
arst.Update
drst.movenext
wend
'open report and assign recordset
docmd.openreport "myReport"
set reports!myReport.Recordset=arst
Alternatively you might put this code in the report load event