title: multiply record my maturity
body: <p>Input:</p>
  
  <p>I have 4 columns in a table:</p>
  
  <pre><code>KONTO   CUSTOMER_NUMBER   COLLATERAL_TYPE   MATURITY
  </code></pre>
  
  <p><code>Konto</code> is unique value, maturity is value I need to multiply.</p>
  
  <p>Example:</p>
  
  <pre><code>KONTO  CUSTOMER_NUMBER  COLLATERAL_TYPE  MATURITY
  --------------------------------------------------
  1           000234           H              4
  2           000234           G              3
  3           212567           H              5
  </code></pre>
  
  <p>I need to create table with every <code>KONTO</code> multiplied my max maturity and collateral type per customer. Maybe its easier to say, each collateral should have record fer every year of maturity</p>
  
  <p>Output:</p>
  
  <pre><code>KONTO  CUSTOMER_NUMBER  COLLATERAL_TYPE  MATURITY
  -------------------------------------------------
  1           000234           H              1
  1           000234           H              2
  1           000234           H              3
  1           000234           H              4
  2           000234           G              1
  2           000234           G              2
  2           000234           G              3
  3           212567           H              1
  3           212567           H              2
  3           212567           H              3
  3           212567           H              4
  3           212567           H              5
  </code></pre>
  
  <p>My colleagues from other firm managed to do it but I don't know how.</p>
  
  <p>I use MS Access/SQL in MS Access.</p>
  
  <p>Thank you and sorry for my bad English</p>