12 months rolling calendar table (1 Viewer)

Guinaba

New member
Local time
Today, 23:08
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

You've got your good things, and you've got mine.
Local time
Today, 08:08
Joined
May 21, 2018
Messages
8,463
Can you clarify what you mean
 

Micron

AWF VIP
Local time
Today, 08:08
Joined
Oct 20, 2018
Messages
3,476
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?
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 08:08
Joined
May 21, 2018
Messages
8,463

 

Attachments

  • Year2.jpg
    Year2.jpg
    93 KB · Views: 1,392
  • calendar1.jpg
    calendar1.jpg
    100.3 KB · Views: 1,563

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:08
Joined
Feb 19, 2002
Messages
42,970
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
Local time
Today, 05:08
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
 

xwavefive

New member
Local time
Today, 17:38
Joined
May 23, 2021
Messages
2
To properly implement your schema, you would have a record for each month rather than a column.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:08
Joined
Oct 29, 2018
Messages
21,357
To properly implement your schema, you would have a record for each month rather than a column.
Hi. Welcome to AWF!

Just FYI, this is over a year old thread.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:08
Joined
Feb 19, 2002
Messages
42,970
But at least you repeated my advice from #8:) Welcome:)
 

Users who are viewing this thread

Top Bottom