Access 2003 - VBA - Recordset into Report - Misc. Calcuations

I am working with Access 2003 and VBA. I have a table in access that contains earnings data for various companies by quarter. I have a form with command buttons that will allow the user to input date ranges, company, etc. With these inputs, the form should then create a table with CAGRs, YTD Growth, QTR over QTR growth, Cur QTR vs Prev. QTR growth. My issue is, in VBA you can create a recordset in memory. I am unable to figure out how to place this recordset in an Access Report. I have come to the conclusion that the only way to do this is to have VBA create a new table and to populate that table with the recordset in memory. I am looking to understand if this is the most efficient way to do this.