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?