Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Kenton, Delaware, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weekly Rollup Groupings (2Access 2003)

    When I set up my weekly roll up report the wizard is very good about labeling the week for me. The problem is that the week grouping value is formatted to print "Week 40" for example.
    Is there a format for this group or a snippet of code that will print Week 40 as a date range or a least show "Week 40 beginning "dd-mmm-yyyy"?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Weekly Rollup Groupings (2Access 2003)

    Say that the date field you're grouping on is named dtmDate. The expression you have now may look like

    ="Week " & Format([dtmDate],"ww",0,0)

    You can change this to

    ="Week " & Format([dtmDate],"ww",0,0) & " beginning " & Format([dtmDate]-Weekday([dtmDate],0)+1,"dd-mmm-yyyy")

Posting Permissions

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