Day calculation

[alainde]

I need to show a particular serie of dates calculated on a specific day during a period of time.
IE: Every monday during the period from Aug 26th 2002 to Dec 24th 2002.

The query behind the report give day as a value (1=sunday 2- monday 3= tuesday etc.) and a startdate enddate.

How can I show all mondays as dates such as:
Monday aug 26th , Monday sept 2, 9, 16...

Your help gratly appreciated,
Bonjour à Tous!
Alain D. Montreal,Qc,Canada

 

[67peshawar294]

If your report has a "date header" create a new txtbox and refer to your datefield.
I just created a report based on weekly totals and had the field =weekday([xdatein]) which lists the weeks as 1,2,3,4,
I created a new txtbox and made the control source =xdatein and the Mondays were all listed in the Header as the actual date.
jim