combine two different tables

  • Thread starter Thread starter cc
  • Start date Start date
C

cc

I was trying to combine two tables into one pivot.

The tables are :
(1) Crew capacity ([Month],[Product Line],[Net Production
Hours])
(2) Demand ([Month],[Product Line], [Qty],[Hours needed]


I need the pivot table to show as below :

[Month] [Month] [Month]
[Product Line] [Net Production Hours])
[Qty]
[Hours needed]

Can anyone help??
 
Hi,


Make a query:

SELECT a.*, b.qty, b.[Hours needed]
FROM [Crew capacity] As a INNER JOIN Demand As b
ON a.[Month]=b.[Month] AND a.[Product Line] = b.[Product Line]



Save it, say, Q1.


Make a crosstab, with the help of the wizard, based on Q1.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top