Combining and Counting by month

[Tcurtis]

I have broken down a lot of data into three tables that I need to count by month. It took a lot of filtering in other queries to get these three tables. Each table represents a type of part, Inhouse, Outsource and New. How can I combine all of these tables into a chart that gives me the count of each by month and kind? Do I need to add a field in each table that identfies the part as one of these three and if so how do I do that? Or can I make a query that will combine these tables and give me a count of each by month and name of table? I am at a loss on this one. Thanks

 

[Namestaken]

Can the data you need out of these three tables be combined into one? If so, I'd recommend a PivotTable with a PivotChart.

Edit: I am sorry, I thought I was in the Excel forum! Although, if you can join the relevant information into one chart, you could import that into an Excel PivotTable and chart the result.

 

[xenou]

You can combine the three tables if they have the same structure:

SELECT *, 'Table1' As SourceTable FROM Table1
UNION ALL
SELECT *, 'Table2' As SourceTable FROM Table2
UNION ALL
SELECT *, 'Table3' As SourceTable FROM Table3


Then you can run a query on that query to sum, count, or what have you.

 

[Tcurtis]

Worked great!!! I really appreciate the help.