If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reposting - If my query finds no data it won't plot that week
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. |
#2
|
|||
|
|||
Reposting - If my query finds no data it won't plot that week
Stu wrote:
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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|