Lambel
asked on
Generate dates in a calendar table
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.