I have a graph that is giving me fits.
It is based on a query. The query returns the expected results if it is run by itself, so the query is fine.
The graph, however, displays exactly one less set of results (either the highest number or lowest, depending on how it is sorted).
I have tried resizing the graph, with no luck. And I have combed through the graph formatting options (what little of it there is), also with no luck. The data table for the graph is not showing the missing number. So somewhere between the query and the graph, Access is dropping the ball.
Any ideas???
It is based on a query. The query returns the expected results if it is run by itself, so the query is fine.
The graph, however, displays exactly one less set of results (either the highest number or lowest, depending on how it is sorted).
I have tried resizing the graph, with no luck. And I have combed through the graph formatting options (what little of it there is), also with no luck. The data table for the graph is not showing the missing number. So somewhere between the query and the graph, Access is dropping the ball.
Any ideas???
Comment