Results 1 to 5 of 5

Thread: Start of Week

  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Start of Week

    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.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Start of Week

    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 <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Start of Week

    See previous post by Denny Ryan.

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=1028&page=&v iew=&sb=&vc=1#Post1028> Denny Ryan Post </A>

  4. #4
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Start of Week

    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?

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Start of Week

    Mark,

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

    Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •