group by week

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping on reports 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Group By Week 2
Cumulative Timesheet Entries 5
How to check for missing required daily entries (records) 10
Suming Up Time over the course of days 1
When building a chart Dates are been included that are not in thedate range 1
Week starts on Friday 2

Top