This query separates the data by looking for the productnumbers with selling data before 2013
SELECT [RoI Actual].[Number]
FROM [RoI Actual]
WHERE ((([RoI Actual].FiscalYear)<#1/1/2013#));
This query searches the complement of those data points and makes a list of the product number of products launched after 2013
SELECT DISTINCT [RoI Actual].Number
FROM [RoI Actual] LEFT JOIN SeparateTheDate ON [RoI Actual].[Number] = SeparateTheDate.[Number]
WHERE (((SeparateTheDate.Number) Is Null));
This generates the same list with the before numbers
SELECT DISTINCT SeparateTheDate.Number
FROM SeparateTheDate;
And these two generate the linkage of the numbers in the list with the data in the original table
SELECT [RoI Actual].[Number], [RoI Actual].FiscalYear, [RoI Actual].SalesEuros, [RoI Actual].Category
FROM After2013 INNER JOIN [RoI Actual] ON [After2013].[Number]=[RoI Actual].[Number];
SELECT Before2013.Number, [RoI Actual].FiscalYear, [RoI Actual].SalesEuros, [RoI Actual].Category
FROM Before2013 INNER JOIN [RoI Actual] ON Before2013.[Number] = [RoI Actual].[Number];
