FW: [AccessD] custom sorts/groups in a report

 Nevermind. :( 

Susan H. 


I'm grouping and sorting a report on a date field. The grouping is by the
week -- but I want it to handle a changing first day of the week variable. I
can't get my head around it at all. 
 
Passing the first day of the week around is no problem -- I just can't seem
to get Access to group by it. I've looked at CreateGroupLevel, but I don't
see how that can help. 
 
I tried adding a DatePart expression to the Detail section and using the
OpenArgs property to pass the first day of the week, and while the
expression works, I can't group by it -- it's a calculated control. I don't
want the users manipulating the underlying query either. They choose the
first day of the week from a simple form and the rest needs to happen behind
the scenes. 
 
Any suggestions?