Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping records by week

    I need to group records in a report by week. It seems Access97's week grouping is from Sunday thru Saturday. I need to group them from Monday - Sunday. How can I do this?

  2. #2
    dennyryan
    Guest

    Re: Grouping records by week

    You should check out the Help on the Format function. I assume that must be how you are getting the grouping by week. Within that function there is a paramter for 'firstdayofweek'. You can use that to specify which weekday is to be considered the first day of the week.

    Denny

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping records by week

    Denny,
    Thanks for the response. I tried working with the "firstdayofweek" parameter, with no luck. I think the problem was with my syntax. Any help on what the syntax would be?

  4. #4
    dennyryan
    Guest

    Re: Grouping records by week

    This syntax seemed to work for me:
    week1: Format(#02/08/2001#,"ww",1) - sets Sunday as the first day of the week (default)
    week2: Format(#02/08/2001#,"ww",3,0) - sets Tuesday as the first day of the week.
    I used 2/08/2001 just to see if I got a different number (which I did, yippee!).

    Hope this helps.

    Denny

  5. #5
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Grouping records by week

    Denny,
    Thanks for the help. I finally got it to work!!

Posting Permissions

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