Sorting by Month, Week, Days

S

Sov

Hello,

I just created some records of shifts for workers, and I need to be able to
sort them by months, weeks and days.

For example, I have 4 record on July 20, 4 on July 21, 7 on July 22 and so on,
I want to be able to show a report where:
July 20 - record 1
record 2
record 3
record 4

July 21 - record 5
record 6

and so on

any help would be appreciated
 
R

Rick B

Then in your grouping and sorting box, do something like this....

=Format([SomeDateFiel],"YYMM")

Then set a group header for that grouping.

In your header, put the date in the format you desire...

=Format([SomeDateField],"MMMM") & " " & Format([SomeDateField],"DD")
 
O

Ofer

To follow Rick's sorting in the Grouping and sorting, you don't have to
create a group header, instead list all the fields together and on the
HideDuplicates Property of the Date field select True
 
S

Sov

Thank you to both
That has been very helpful

Ofer said:
To follow Rick's sorting in the Grouping and sorting, you don't have to
create a group header, instead list all the fields together and on the
HideDuplicates Property of the Date field select True
Click to expand...
 
Top