[AccessD] custom sorts/groups in a report

On 17 Apr 2004 at 18:46, Susan Harkins wrote:

> 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. 
>  

You can group by a calculation.
Just put =Datepart("ww",mydate,myfirstday) in a grouping level.

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.