Grouping a weekly basis

[paulmcdonnell]

Hi guys...

I've got a report which produces lists of appointments ordered by date (diary style). I want to group these appointments, so that they appear on the report per week with dividing lines between the weeks. I'm having trouble with the group method to keep one week, a monday to friday together....

Any one have any ideas

Cheers
paul

 

[ScpttCybak]

You can use expressions in the sorting/grouping dialog, eg, to group by week, you need to only have a datefield to base it on, the expression would look similar to:

=Abs(Format([DateField], "w"))

HTH