Help with new DATE project

[Jeff C]

I have a large amount of daily data that I have already built queries and
reports to return totals and percentages by subject and department based on
the counting of yes/no fields by selecting the date period desired.

I would like to produce a report that returns these totals on a weekly basis:


wk1 wk2 wk3 etc

dept

and

wk1 wk 2 wk3 etc

subject


can someone point me to or advise of a solution?

Thank you in advance

 

[Duane Hookom]

I would think you could use a crosstab query. I generally create a column
heading expression using the DateDiff() function. You can allow users to
enter an Ending Date in a text box on a form ane calculate the week number
with an expression like:
ColHead: "Wk" & DateDiff("ww",[DateField],
[Forms]![frmDates]![txtEndDate])

You would need to enter the data type of all parameters by selecting
Query->Parameters
[Forms]![frmDates]![txtEndDate] DateTime

"Wk0" would return data for the Ending Date week.