Report Using Crosstab Query

[Rey]

I am trying to build a report that has week ending dates across the
top (example 12/22/07, 12/29/07, 1/5/08) and Driver Names down the
left side. I would like to have the report populate a scheduled date
that falls in between the range. My crosstab query only tries to
count or sum the dates.

 

[Duane Hookom]

There is a solution for creating crosstab reports based on date intervals at
http://www.tek-tips.com/faqs.cfm?fid=5466. This uses months but it shouldn't
be too difficult to change to weeks.