[AccessD] custom sorts/groups in a report

Have you tried an expression in your query like:

GroupDay:
(Weekday([DateField])+IIf(Weekday([DateField])<[FirstDayOfWeek],7,0))

For a FirstDayOfWeek = 4 (Wednesday), it would return the desired grouping
order:

WeekDay   GroupDay
  4         4
  5         5
  6         6
  7         7
  1         8
  2         9
  3         10

This way, you can avoid any function or calculated control on your report.
You could replace [FirstDayOfWeek] with WeekDay(Date()), or source it from a
form.

-Ken

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net]
Sent: Tuesday, April 20, 2004 12:49 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] custom sorts/groups in a report


That's what I'd like to do -- and may do yet  by passing the firstdayofweek
value from the form to the query instead of the report. Truth is, I don't
know how -- I can't remember ever passing a value to a query before and a
parameter query is out.

Susan H.

Right.  Except when I need to sort or group on an unbound control.  That's
when I have to add it to the query and bind the control to that field in the
query.