Pls allow me to ask this, probably for you, basic question.
I've searched for the solution and came up with some but I don't seem to be able to add it to the code below.
I'm trying to create a db that will generate an default xls report.
This report will be used for postprocessing in xls.
what I try to do: I am having 1 element that consists of different unit types.
Each unit type is multiple times available in the element.
so we assume, 1 element has 2 unit types and each unit type has 2 units. This would result in 4 units being installed.
I have the code to generate the 2 records for each unit type at once with some basic date like prices etc.
NE_ID = Me.NE_ID
phase = Me.[SF_RollOut].Form![PhaseDescription]
price = Me.price
unit_types = Me.UnitTyperPerNE
For counter = 1 To unit_types
mysql = "insert into [T_phasesUnits] (NE_ID, PhaseDescription, price) VALUES (" & NE_ID & "," & phase & "," & price & ");"
Now I would like to implement some phases (years) to it.
In 2009, we will have an installed base of 4 units
In 2010, we will have an installed base of 8 units.
When the above code is run, it fills the table T_phasesUnits with the correct data, but only for the 1st phase.
How do I have to do so that all phases will be processed?