Reposting - If my query finds no data it won't plot that week

[Guest]

I'm running a query which calculates data for eight weeks and returns eight
records. If the query finds no data for one of those weeks it returns only 7
records and the chart only shows only 7 weeks. I want the chart to plot the
"missing" week as (zero), so it always shows eight weeks. if I can get the
query to return a blank record for each "missing" week I'd always get 8
records to plot on the chart. Please advise.

 

[Marshall Barton]

I'm running a query which calculates data for eight weeks and returns eight
records. If the query finds no data for one of those weeks it returns only 7
records and the chart only shows only 7 weeks. I want the chart to plot the
"missing" week as (zero), so it always shows eight weeks. if I can get the
query to return a blank record for each "missing" week I'd always get 8
records to plot on the chart.

To do that, you need some data somewhere for each week.

In a crosstab query it can be in the query's Headings
property.

In other cases, you'll need another table with all the
weeks. How this would be done depends on you table and the
query you are using.