Sorting/Grouping Assistance 1

[Mike555]

Maybe I'm trying to accomplish the impossible, but here goes...

I have a report in which data needs to be sorted by "DueDate" and grouped by "OrderNum". Therefore the report is sorted/grouped by both fields DueDate and OrderNum. But by creating a sorting/group for OrderNum (so that I may group data by OrderNum) data is also sorted by OrderNum within the OrderNum GroupHeader. Therefore my data may look something like this...

DueDate GroupHeader (By Week)
"Week of 01/01/05"
OrderNum GroupHeader
OrderNum: 789 DueDate: 01/03/05
OrderNum: 790 DueDate: 01/01/05
OrderNum: 791 DueDate: 01/03/05
OrderNum: 792 DueDate: 01/02/05

...and my users say "I need it to sort everything by Due Date."

Is there some way that I can sort by DueDate within the OrderNum header? Or, is there some way that I can Group By OrderNum without sorting by OrderNum? Any assistance or direction would be appreciated. Thanks.


--
Not until I became a Network Administrator did the error message "See your Network Administrator for assistance" become petrifying.

 

[dhookom]

Why do you show an OrderNum Group header with 4 different OrderNums under it?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Mike555]

It should actually look like this, I appologize:
DueDate GroupHeader (By Week)
"Week of 01/01/05"
OrderNum GroupHeader
OrderNum: 789 DueDate: 01/03/05
OrderNum GroupHeader
OrderNum: 790 DueDate: 01/01/05
OrderNum GroupHeader
OrderNum: 791 DueDate: 01/03/05
OrderNum GroupHeader
OrderNum: 792 DueDate: 01/02/05

BTW The detail area is invisible also. Thanks.


--
Not until I became a Network Administrator did the error message "See your Network Administrator for assistance" become petrifying.

 

[dhookom]

Have you tried grouping by the week of the due date and then the actual due date. The OrderNum would be the third level of grouping.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Mike555]

That's a good idea, I'll try it.
PS - Thanks for answering my MS Newsgroups post, too.


--
Not until I became a Network Administrator did the error message "See your Network Administrator for assistance" become petrifying.