Hello, New here

[wes95]

I have a question, I am kinda a newbie in access, and I want to create a calendar, with
1. Year selection, and below that
2. Months (buttons) and below that
3. Days and Dates
- Days (Static)
- Dates (Dynamic) following year and months selection

I have already configured the year, and month buttons but the issue is with the calendar, it seems to be breaking weekly and not a continuous one-row from 1st - to 31st,
Anyone to assist in achieving this, Thank you

Attached is my Crosstab Query, a form, and the query SQL code:

TRANSFORM Min(TempDaysAndDates.DayNumber) AS MinOfDayNumber
SELECT TempDaysAndDates.WeekNumber
FROM TempDaysAndDates
GROUP BY TempDaysAndDates.WeekNumber
PIVOT TempDaysAndDates.DayName In ("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat");

 

[The_Doc_Man]

First, Wes95, hello and welcome to the forums.

Second, I am going to move your request to the GENERAL forum because you stated a technical question in your first post. We tend to keep the "Introductions" forum dedicated to introductions. We're kind of literal-minded sometimes.

 

[DHookom]

It looks like the crosstab is doing what you asked it to do. Can you provide a screen shot or other of what you expect/want?