Hi
I am trying to create a query that will pull information off of two tables. Table one and table two. In table one, I have two fields, scraps and repairs. In table two, I have two fields, scraps and repairs. The tables are from two different department. What I want the query to do is add everything in field one, field two, field three, and field four. Not together, just.... basically, adding the columns so I get four totals. I want to use these totals later for a chart to compare the scraps and repairs in each department. When I create a query to do this, it doesn't work, however if I create two seperate queries for the two seperate tables, it works great!! However, when I use the chart wizard, I can only choose one table or query, not both. So, I'm stuck in the middle. Does anybody have any ideas on how to create this query
I am trying to create a query that will pull information off of two tables. Table one and table two. In table one, I have two fields, scraps and repairs. In table two, I have two fields, scraps and repairs. The tables are from two different department. What I want the query to do is add everything in field one, field two, field three, and field four. Not together, just.... basically, adding the columns so I get four totals. I want to use these totals later for a chart to compare the scraps and repairs in each department. When I create a query to do this, it doesn't work, however if I create two seperate queries for the two seperate tables, it works great!! However, when I use the chart wizard, I can only choose one table or query, not both. So, I'm stuck in the middle. Does anybody have any ideas on how to create this query