Help Please.. Need to know how to create a dynamic array in Access 2003?

I'm trying to create an array from a query in MS Access 2003. The array will be used to display statistical data for 12 months (periods) and will consist of 4 main elements: PeriodID, PeriodEnd_date, Total_qty and Total_Value.

The query will summarise the required data, based on user input (starting Period), but this does not always produce 12 rows of data as some periods have no records. What I want to do is perform a data check as it creates the array, and populate the QTY and value fields with zeros where there is a period within the specified range with no records. The desired end result is an array that will contain exactly 12 records. I know it must be possible, but for the life of me I can't figure it out.

Is there anyone out there who can provide maybe an example in VBA that could work for me?

Thanks.