Problem with week to week

[Bozer]

Good evening,
I have built a time and attendance databaseand am having trouble showing week by week starting on a Wednesday. I have adjusted my group settings all over
but it allways starts a new week from the monday on the report. I can display Monday to Sunday no problem and the weeks show on each group but I cant get wednesday
to wednesday to work.

Thanks

[June7]

Post your code. How are you calculating 'group settings'?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Bozer]

Thanks for the reply, I can now see the problem which is due to my grouping looking at a week number.
But what I want s for the report to group Wednesday to Wednesday, I expect that the fix will be pretty easy.
My report is looking at a query and this has all then data complete with dates, days of week etc

Thanks
Clive

[June7]

Calculate Wednesday date for the week each date in record falls in. Use that for grouping. This calc is a fairly common topic.

WedDte: fieldname - Weekday(fieldname, vbWednesday) + 1
or
WedDte: DateAdd("d",1-Weekday(fieldname, vbWednesday), fieldname)

Cannot include time components in saved date value. If there is time part, will have to adjust code to extract only date part. DateValue() function can do that.

[Bozer]

Thanks for your help with this June7, I couldnt get the code to work but it helped point me to the solution.

Field: DatePart("ww",[EntryDate], "4")
and it was the 4 above starting my week on Wednesday that fixed my issue.

Again thanks for your help

Bozer