budgets.PNG

<div>
Gus, What does MSysObjects have to do with this?
</div>


Gus, What does MSysObjects have to do with this?

<div>
Nothing, except that it is present and ready to serve you, so you need nothing more than the Budgets table and the query.<br />
<br />
/gustav
</div>


Nothing, except that it is present and ready to serve you, so you need nothing more than the Budgets table and the query.

/gustav

<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
A company has three budgets. &nbsp;<br />
<br />
Budget 1 has 3 months at 8000<br />
Budget 2 has 2 months at 6000<br />
Budget 3 has 1 month at 4000<br />
<br />
Looking a creative way to create a recordset to show the following.<br />
month 1 8000<br />
month 2 8000<br />
month 3 8000<br />
month 4 6000<br />
month 5 6000<br />
month 6 4000<br />
<br />
Depending on the company there may be 1 to ? number of budgets.
</div>
</div>


A company has three budgets.  

Budget 1 has 3 months at 8000
Budget 2 has 2 months at 6000
Budget 3 has 1 month at 4000

Looking a creative way to create a recordset to show the following.
month 1 8000
month 2 8000
month 3 8000
month 4 6000
month 5 6000
month 6 4000

Depending on the company there may be 1 to ? number of budgets.

Create a varying recordset

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.