group by week

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

When i group a date field by week on a report in Access 97 the report
correctly splits by week but the dates are all mixed up
I have set it to not pint out weekends only week days and if i remove the
grouping it works fine. But i need this grouping in so i can do some
calculations on the grouop footer

I get something like this

Tuesday 02-Dec-03
Wednesday 03-Dec-03
Thusday 04-Dec-03
Friday 05-Dec-03
Monday 01-Dec-03

Friday 12-Dec-03
Monday 08-Dec-03
Tuesday 09-Dec-03
Wednesday 10-Dec-03
Thursday 11-Dec-03


Any ideas appreciated

Cheers
Dave
 
Back
Top