M MICHELE Registered User. Local time Today, 14:07 Joined Jul 6, 2000 Messages 117 Feb 27, 2002 #1 I have a report grouped and sorted by load date weekly and monthly. On the weekly group header I would like to have a week beginning field so that it always has Monday's date for that week.
I have a report grouped and sorted by load date weekly and monthly. On the weekly group header I would like to have a week beginning field so that it always has Monday's date for that week.
S SimonC Registered User. Local time Today, 14:07 Joined Feb 25, 2002 Messages 48 Mar 1, 2002 #2 Try this formula in either the report or the underlying query: DateAdd("d",-(Weekday([LoadDate],2)-1),[LoadDate])
Try this formula in either the report or the underlying query: DateAdd("d",-(Weekday([LoadDate],2)-1),[LoadDate])
