Start of Week

Topic

New Reply

Does anyone know how to get Access to use Monday as the start of the week instead of Sunday. I’m doing a calendar database for a church and they need a weekly report that shows Mon-Sun.

Reply | Quote

Replies

Hi Jim,

Two things:
1) Check into the function called Weekday(). It has an argument that allows you to specify which day is the first day of the week. You can read more about it in the Access helpfiles.
2) Can you provide a specific example, either of code or SQL that contains the issue in question. It always helps to see the specific problem.

HTH

Reply | Quote

Thanks pointing me in the right direction.

I’ve been playing around with the weekday function in the report and I’m still not getting the results I need. here is the SQl statement for the report.

SELECT DISTINCTROW FacilitySchedule.Date, Weekday([Date],2) AS Weekday, Format([date],”dddd”) AS Day, Events.EventName, FacilitySchedule.BTime, FacilitySchedule.ETime, FacilitySchedule.RoomName
FROM Events INNER JOIN FacilitySchedule ON Events.EventID = FacilitySchedule.EventID
WHERE (((FacilitySchedule.Date)>=[forms]![Report Date Range]![BegDate] And (FacilitySchedule.Date)<=[forms]![Report Date Range]![EndDate]))
ORDER BY FacilitySchedule.Date, Weekday([Date],2);

I need to see events one week at a time per page Monday-Sunday for the date range the user enters. I've been trying different groupings and intervals on the report using the weekday function. I got pretty close once where it put Monday first and then everything within 6 days after Monday but then it put ALL the sundays at the end. Any ideas?

Reply | Quote

Mark,

I went to Rupert’s message and I figured it out! Thanks!

Jim

Reply | Quote

See previous post by Denny Ryan.

Denny Ryan Post

Reply | Quote