I have a table with two columns called FromDate and ToDate indicating the start and end of a student's program. Since the client sells it's programs by weeks, they would like a report that shows the number of weeks sold for every week of the year.
The challenge is to get a crosstab query to...