Susan Harkins
ssharkins at bellsouth.net
Tue Apr 20 06:56:31 CDT 2004
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.