Group by Date; Keep Week Together

  • Thread starter Thread starter Eileen
  • Start date Start date
E

Eileen

I have a report grouped by Week. When I pull 3/1/04
through 4/2/04, the last week is separated into 3/28/04
thru 3/31/04, and 4/1/04 thru 4/2/04. I need to have all
dates shown under that week's heading. I have the Sorting
& Grouping for the Date field set Group On Week, Keep
Together with First Detail. I've also tried keep whole
group together.

Thanks,
Mary
 
Are you also grouping by Month? If you are only grouping by Week then 3/28 -
4/2 should be in the same week group.
 
You must log in or register to reply here.

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

Query gives correct result set while the report does not 2
Custom Grouping 1
Group by week 2
Formula to report dates in a new tab 2
Calculating a week between a range of dates 3
Summarise by week 6
conditional running sum 7
Running total by group 1

Back
Top