Thank you for your help, Bob. I apologize for not providing the correct amount of information.
The 1st SQL Query pulls data from my master data sheet and creates a Product Table:
Code:
SELECT [Master Data].[Product Number], [Master Data].[Product Name], [Master Data].[Product Time],
[Master Data].[Product Region], [Master Data].[Manager], [Master Data].[Expected Sale Profit],
[Master Data].[Expected Sale Tax], [Master Data].[Manager Code]
FROM [Master Data]
GROUP BY [Master Data].[Product Number], [Master Data].[Product Name], [Master Data].[Product Time],
[Master Data].[Product Region], [Master Data].[Manager], [Master Data].[Expected Sale Profit],
[Master Data].[Expected Sale Tax], [Master Data].[Manager Code]
HAVING (([Master Data].[Manager Code ])="Specific Name"));
Product Table
Product Number
Product Name
Product Time
Product Region
Manager
Expected Sale Profit
Expected Sale Tax
With the query created Product Table, I then join the Product Table with the Store Table to create the Combined Table:
Code:
SELECT [Product].[Product Number], [Product].[Product Name], [Product].[Product Time],
[Product].[Product Region], [Product].[Manager], [Product].[Expected Sale Profit],
[Product].[Expected Sale Tax], Store.[Product Status], Store.[Product Store],
Store.[Store Number], Store.[NWest Sales], Store.[SWest Sales], Store.[NEast Sales],
Store.[SEast Sales]
FROM [Product] INNER JOIN Store ON [Product].[Product Number] = Store.[Product Number];
Combined Table
Product Number
Product Name
Product Time
Product Region
Manager
Expected Sale Profit
Expected Sale Tax
Product Status
Product Store
Store Number
NWest Sales
NEast Sales
SWest Sales
SEast Sales
My update query that is not working is joining the Combined table with the Master Product table:
Code:
UPDATE [Master Product]
LEFT JOIN [Combined] ON [Master Product].[Product Number] = [Combined].[Product Number]
SET [Master Product].[Product Name] = [Combined].[Product Name],
[Master Product].Timing = [Combined].[Product Time],
[Master Product].[Region] = [Combined].[Product Region],
[Master Product].[Manager Name] = [Combined].[Manager],
[Master Product].[Sale Profit] = [Combined].[Expected Sale Profit],
[Master Product].[Sale Tax] = [Combined].[Expected Sale Tax],
[Master Product].[Product Status] = [Combined].[Product Status],
[Master Product].[Store Name] = [Combined].[Product Store],
[Master Product].[Store Code] = [Combined].[Store Number],
[Master Product].[NW Sales] = [Combined].[NWest Sales],
[Master Product].[NE Sales] = [Combined].[NEast Sales],
[Master Product].[SW Sales] = [Combined].[SWest Sales],
[Master Product].[SE Sales] = [Combined].[SEast Sales];