[AccessD] custom sorts/groups in a report

Glad to see I am not the only frustrated programmer on A Saturday
Afternoon.

JOE HECHT
LOS ANGELES CA 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Saturday, April 17, 2004 4:21 PM
To: 'Access Developers discussion and problem solving'
Subject: 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? 

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com