Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
<body><p>Hi,</p> <p>I've got a minor problem! </p> <p> </p> <p>I've got some database records like this these:</p> <p> </p> <p> </p> <p> </p> <p> <tr height="20"> <td height="20" width="64">Order no. </td> <td width="73">Campaign start</td> <td width="73">Campaign end</td> <td width="64">Amount of order</td> <td width="64">Campaign period (days)</td> <td colspan="2" width="128">Amount per day (amount of order / period)</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">01-01-2010</td> <td align="right">07-01-2010</td> <td align="right">10000</td> <td align="right">7</td> <td align="right">1428,571</td> <td></td> </tr> <tr height="20"> <td height="20" align="right">2</td> <td align="right">06-01-2010</td> <td align="right">08-01-2010</td> <td align="right">2000</td> <td align="right">3</td> <td align="right"> <p>666,6667</p> </td> </tr> </p> <p> </p> <p> </p> <p> </p> <p>I'd like QV to autogenerate records like the ones below:</p> <p> </p> <p> </p> <p> </p> <p><col width="64"></col> <col width="73" span="2"></col> <tr height="20"> <td height="20" width="64">Order no. </td> <td width="73">Date</td> <td width="73">Amount per day</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">01-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">02-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">03-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">04-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">05-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">06-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">1</td> <td align="right">07-01-2010</td> <td align="right">1428,5714</td> </tr> <tr height="20"> <td height="20" align="right">2</td> <td align="right">06-01-2010</td> <td align="right">666,66667</td> </tr> <tr height="20"> <td height="20" align="right">2</td> <td align="right">07-01-2010</td> <td align="right">666,66667</td> </tr> <tr height="20"> <td height="20" align="right">2</td> <td align="right">08-01-2010</td> <td align="right">666,66667</td> </tr> </p> <p> </p> <p>I've tried using Autogenerate, but I'm getting no where. Can you help me?</p> <p>Thank for helping. </p> <p>Best regard</p> <p>Mike</p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p><col width="64"></col><col width="73" span="2"></col><col width="64" span="4"></col> <tr height="20"> <td height="20" width="64"><br /></td> <td width="73"><br /></td> <td width="73"><br /></td> <td width="64"><br /></td> <td width="64"><br /></td> <td colspan="2" width="128"><br /></td> </tr> </p> <p> </p> <p> </p> <p> </p></body>
Hi,
You should try to generete a Calendar Table : A table with one line per day
Then use the IntervalMatch function to map the calendar and the table containing the data
Hope this helps
Pierre.
