12 months rolling calendar table (1 Viewer)

Guinaba

New member
Joined
Jan 14, 2020
Messages
2
Hello experts,

Does someone know how to create a dynamic rolling 12 months calendar table in Access?

Regards,

Gilly
 

MajP

I wish I could go back in time... I'd take state
Joined
May 21, 2018
Messages
2,459
Can you clarify what you mean
 

Micron

AWF VIP
Joined
Oct 20, 2018
Messages
1,795
If by "rolling" you mean horizontally in a table this idea doesn't conform to table design. If you mean some kind of form, then maybe. Are you looking for some kind of Outlook Calendar thing but created in Access?
 

Pat Hartman

Super Moderator
Staff member
Joined
Feb 19, 2002
Messages
28,546
When working with a relational database, think tall and thin rather than short and wide. To properly implement your schema, you would have a record for each month rather than a column. To control what months are selected, you would use criteria in a query. If you want to pivot the result so it looks like a spreadsheet for reporting, you can use a crosstab query.
 

adomanim

New member
Joined
Dec 25, 2019
Messages
7
My timetable at work is very confusing, I have been trying to make it automated in Excel but am having no luck.

Essentially, I am at different locations depending on day of the week in relation to the month. For example, The 4th monday of every month I am at one place, the 3rd Tuesday of every month I am at another place.

The timetable we are given is set out as a 5 week month, as there can be more than 4 Tuesdays in a month etc.











Lucky Patcher Kodi nox
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom