<div>
<div class="content wysiwyg-content">
I want to generate a calendar in an Access database that goes out 3 months or up to a year. &nbsp;I would like to populate a table with a record for each day, and identify if the day is the first day of the month or the last day of the month (possibly with a yes/no flag). &nbsp;<br />
<br />
I hope to then use this calendar to project out a home budget and indicate cash flow based on current bank balance and upcoming paydays.<br />
<br />
I'm stumped how to generate the table. &nbsp;Any advice?
</div>
</div>


I want to generate a calendar in an Access database that goes out 3 months or up to a year.  I would like to populate a table with a record for each day, and identify if the day is the first day of the month or the last day of the month (possibly with a yes/no flag).  

I hope to then use this calendar to project out a home budget and indicate cash flow based on current bank balance and upcoming paydays.

I'm stumped how to generate the table.  Any advice?

Generate dates in a calendar table

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.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.