Graph - Null / Zero Problem

[z.ghulam]

Hi,


I have a line graph used to tally up the number of orders each engineer

does in a week. This works well apart from 2 things:


1) If an engineer is off for a week or completes 0 orders, then there
is no record of a 0 in the database and so there is a break in the line

graph. Whjat I would like is the line graph to show a value of 0 for
these periods. Is there any way to get Access to create a default zero
value in the graph if no records exist?


2) There are a number of engineers who are represented by the lines on
the graph. I would like to change the colour of the key, but when I go
into the graph design, only 3 of the engineers show up on the key, even

though all of them show up when the graph is in preview mode.
Is this some sort of glich - or is it a setting that has to be tweaked.



Thanks in advance - any help greatly appreciated.

 

[Arvin Meyer [MVP]]

Use an outer join in a query to a table of all weeks to generate a null
value for every engineer for every week. Then use that query as the basis
for your graph. The NZ() function will convert your nulls to zero.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[z.ghulam]

Cheers Arvin, but would you be able to dumb down your reply, lol.
Basically, do you mean create a dummy table with 2 fields - Date and
Engineer, with a combination of every engineer for every week?
Then create a query using an outer join.........this is where I get a
bit lost.
Thanks for your reply.