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

Cancelled Posted May 21, 2009 Paid on delivery
Cancelled Paid on delivery

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.

Engineering Microsoft Microsoft Access MySQL PHP Project Management Software Architecture Software Testing Visual Basic for Apps Windows Desktop

Project ID: #3897853

About the project

Remote project Active May 21, 2009