Access charts

[chienandalusia]

I have a database with three tables. One table has a list of tools, one table has a list of errors, and the third is updated each time a tool has an error.

I have weekly charts that I pull to see how many errors the tools have in that week. However, the tools that don't have errors and errors that do not occur aren't listed. I would like both to show up in the charts to make week to week comparisons easier.

By using outer joins in a query I can get either all of the tools to show or all of the errors to show but I get a SQL error when I attempt to do both outer joins at the same time.

Is there another way that I can get both to show up?

Thanks,
tony

 

[PHV]

You may consider UNION query

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244