Show start of week between dates

[Perceptus]

Using Access 2007



I have a Data set that contains a Customer Name, Sales Order and Date. I would like to have the report have a bar like chart for each record that shows the date from the record within the range of dates in the data set. Including a value for each start of week even if there is no data for that week.

Do I need to create and populate a table to achieve this in a report?

[June7]

Possible options:

1. need a dataset of every possible combination of week start date and customer - this dataset might be generated by a Cartesian query (a query with no JOIN clause and no WHERE clause that links on common identifier fields) which causes each record of each table to join with every record of other table

2. domain aggregate functions (DSum, DCount, DAvg, etc)