 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / April 2008Group Week Sunday to Saturday
Hi Groupies: I have a report that lists employee pay. The report is currently grouped by week and then by employee. Everything works fine, except that I would like the Date Header label to be: "For Week Ending - ....." with the last date of the week showing up after the hyphen. So like this: For Week Ending - April 12, 2008 For Week Ending - April 19, 2008 At the moment my report is grouped by the dtmDate field and the interval is set at Week. Sunday is the first day, Saturday is the last. I have ="For Week Ending - " & Format$([dtmDate],"mmmm dd, yyyy",0,0) in the label for the date header I believe that I need to replace dtmDate with an expression in the Grouping box but what should the expression be?  SignatureThanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! =DateValue(Int(NZ([DateField])))+1-DatePart("w",DateValue(Int(NZ([Datefield] )))) gets you the weekstart date of a date range so you could add 6 to get the weekend date. you'll be able to do this more simply now you've got the idea but I'm half-asleep at the mo. Evi > Hi Groupies: > [quoted text clipped - 22 lines] > --------------------------------------------------------- > Know thyself, know thy limits....know thy newsgroups! Wow, you can put that together when you're half asleep!!! Thanks a bunch, it worked perfectly after I added +6 to the end! --- CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! > =DateValue(Int(NZ([DateField])))+1-DatePart("w",DateValue(Int(NZ([Datefield] > )))) [quoted text clipped - 34 lines] >> --------------------------------------------------------- >> Know thyself, know thy limits....know thy newsgroups! Are you the CJ of the JOURNEY rock band forum fame? Oh what a riot! Although I am very familiar and was a big fan of Journey.....No, I have never been to a Journey band forum. Ciao, CJ > Are you the CJ of the JOURNEY rock band forum fame? > Oh what a riot! > [quoted text clipped - 12 lines] > > - Show quoted text - WAS a fan of JOURNEY!? WAS!? There is no WAS! Once a JOURNEY fan ALWAYS a JOURNEY fan! Their new album REVELATION is due out June 3rd exclusively at Wal*Mart. They've got a new lead singer named Arnel Pineda and he's sure to help put them back on the map. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.