I do not know how to remove duplicates from my report. It is affecting all but one month, august.
SELECT a.Day AS Week, b.Plant, b.Component, b.Description, b.WeeklyUsageForecast AS WeeklyUsageForecastFromMonthly, b.Month, b.RM_Usage_Percentage, b.Forecast, b.DaysInMonth, b.WeeksInMonth, b.MonthlyUsageForecast, b.DailyUsageForecast
FROM (daysWeeks AS a INNER JOIN ForecastCalculations AS b ON a.Month = b.Month) INNER JOIN UserInput ON (b.Plant = UserInput.Plant) AND (b.Component = UserInput.Matnr)
GROUP BY a.Day, b.Plant, b.Component, b.Description, b.WeeklyUsageForecast, b.[HALB/KMAT Material], b.Month, b.RM_Usage_Percentage, b.Forecast, b.DaysInMonth, b.WeeksInMonth, b.MonthlyUsageForecast, b.DailyUsageForecast;
SELECT a.Day AS Week, b.Plant, b.Component, b.Description, b.WeeklyUsageForecast AS WeeklyUsageForecastFromMonthly, b.Month, b.RM_Usage_Percentage, b.Forecast, b.DaysInMonth, b.WeeksInMonth, b.MonthlyUsageForecast, b.DailyUsageForecast
FROM (daysWeeks AS a INNER JOIN ForecastCalculations AS b ON a.Month = b.Month) INNER JOIN UserInput ON (b.Plant = UserInput.Plant) AND (b.Component = UserInput.Matnr)
GROUP BY a.Day, b.Plant, b.Component, b.Description, b.WeeklyUsageForecast, b.[HALB/KMAT Material], b.Month, b.RM_Usage_Percentage, b.Forecast, b.DaysInMonth, b.WeeksInMonth, b.MonthlyUsageForecast, b.DailyUsageForecast;
