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

Question

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.

Answer 1

TOTAL CONTROL WITH VBA
Controlling execution sequence

* Creating decision-making logic
* Building iteration statements
* Queries and the Immediate If (IIf)
* Populating fixed and dynamic arrays