[AccessD] custom sorts/groups in a report

Susan:

When I run into this problem I have to add the calculation to the query
that's the recordsource for the report.  Then I can group and sort on it.

Rocky

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Tuesday, April 20, 2004 4:56 AM
Subject: RE: [AccessD] custom sorts/groups in a report


> Already tried it -- didn't work. Access will not group on a calculated
> control.
>
> Susan H.
>
> Hi Susan
>
> Perhaps you On_Open of the report could set the value of a textbox to the
> value of your chosen FirstDayOfWeek retrieved from your form; then use the
> value of this textbox as a parameter in the function you use for
> grouping/sorting in your report.
>
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>