Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group by week - Saturday to Friday

Status
Not open for further replies.
traycee

traycee

IS-IT--Management
Sep 6, 2001
245
US
Hi,
I'm hoping this has a simple answer. Our work week has changed. I have several reports which group by week. The field I'm grouping by is [DateOfService]. Currently, I use this formula =Format$([DateOfService],"mm/dd/yyyy",0,0) in the group header to accomplish this. Is there some way I can change this formula...so that everything on my reports stay the same, but that the grouping by week is Saturday to Friday instead of Sunday through Monday.
Thanks :eek:)
 
Sort by date Sort by votes
I don't see any "week" formatting in your expression. You can subtract a day from DateOfService.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Search by Date and Some Text
Replies
9
Views
281
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
509
dhookom
dhookom
iamchemist
  • Locked
  • Question
Push To WORD?
Replies
3
Views
448
iamchemist
iamchemist
GPnew
  • Locked
  • Question
Give each line in group the same number on a report line 1
Replies
10
Views
484
GPnew
GPnew
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
3K
EwaFAMA
EwaFAMA

Part and Inventory Search

Sponsor

Back
Top