SELECT     [tblDatesandM&Es].ForecastDate, [tblDatesandM&Es].ME_PART_NUMBER,
                          (SELECT     COUNT([Min Date])
                            FROM          [tblJustM&EandMinDate]
                            WHERE      [tblJustM&EandMinDate].[Min Date] BETWEEN [tblDatesandM&Es].[ForecastDate] - [tblTATStats].[AvgOfTAT] AND
                                                   [tblDatesandM&Es].[ForecastDate] + [tblTATStats].[AvgOfTAT] AND
                                                   [tblJustM&EandMinDate].[ME_PART_NUMBER] = [tblDatesandM&Es].[ME_PART_NUMBER]) AS Bunching,
                      tblCOQforCalculation.Count AS COQ, CASE WHEN ([Count] >= 4) THEN ([Count] * 0.5) ELSE '2' END AS [COQ Threshold],
FROM         (tblCOQforCalculation INNER JOIN
                      ([tblDatesandM&Es] INNER JOIN
                      [tblJustM&EandMinDate] ON [tblDatesandM&Es].ME_PART_NUMBER = [tblJustM&EandMinDate].ME_PART_NUMBER) ON
                      tblCOQforCalculation.ME_PART_NUMBER = [tblDatesandM&Es].ME_PART_NUMBER) INNER JOIN
                      tblTATStats ON [tblDatesandM&Es].ME_PART_NUMBER = tblTATStats.ME_PART_NUMBER;