D
David
The SQL You Requested:
SELECT [Weekly Sales].WeekEndingDate
FROM ([Sales Category] LEFT JOIN [Weekly Sales] ON [Sales
Category].SalesCategoryID = [Weekly
Sales].SalesCategoryID) LEFT JOIN ((Wages LEFT JOIN [Wage
Detail] ON Wages.WageID = [Wage Detail].WageID) LEFT JOIN
[Weekly Sales Detail] ON [Wage Detail].WageDetailID =
[Weekly Sales Detail].WageDetailID) ON [Weekly
Sales].WeeklySalesID = [Weekly Sales Detail].WeeklySalesID;
Thank You
SELECT [Weekly Sales].WeekEndingDate
FROM ([Sales Category] LEFT JOIN [Weekly Sales] ON [Sales
Category].SalesCategoryID = [Weekly
Sales].SalesCategoryID) LEFT JOIN ((Wages LEFT JOIN [Wage
Detail] ON Wages.WageID = [Wage Detail].WageID) LEFT JOIN
[Weekly Sales Detail] ON [Wage Detail].WageDetailID =
[Weekly Sales Detail].WageDetailID) ON [Weekly
Sales].WeeklySalesID = [Weekly Sales Detail].WeeklySalesID;
Thank You