The manager would like to reward the employees with net sales over $100,000 during 2016 and 2017. The Manager would like the resulting query to display the following information: Employee Name (First and Last as one field), total net sales per employee. (Both years should be combined into one number.) Sort largest to smallest.

Need help getting my query to display the right output. My query should show 7 records but instead shows 9 because it is not filtering out numbers below $100,000 for the combined years of 2016 and 2017. How do I get it my query to run to only show combined net sales of under $100,000? The formula I used in builder is correct as it displays the right output of employees in $, I just have too many records showing. Employees Anne and Steven should not show when I run my query.

File Home Create External Data Database Tools Help Query Design Tell me what you want to do Union Et Insert Rows 3x Delete Rows Builder Insert Columns LJ Delete Columns Return: All B Property Sheet * Table Names View Pass-Through N Data Definition Run Select Make Append Update Crosstab Delete Table Totals Parameters Add Tables Results Query Type Query Setup Show/Hide Chocolate and Coffee Products X Net Sales Employee X All Access Obje... Employees x Sales Salelines Search.. Tables Categories Customers Order ID Customer ID Employee ID Ship Date Shipper Id Freight Charge Employees Sales Invoice ID Product ID Price per Quantity_sold Item Discount Orderlines Orders Product Cost Products Employees Salelines Sales Shippers 1 Employee_ID emp_Lastname emp_Firstname emp_Title emp_Birth_Date I Suppliers Queries Chocolate and Coffee Products Net Sales Employee + Field: Employee ID Table: Sales Total: Group By Sort: Show: Criteria: Net Sales: Salelines]! emp_Firstname Employees Sum Group By emp_Lastname Employees Group By Ship Date Sales Where IS D 0 D n Like *2016* Or Like * or: Employees N Chocolate and Coffee Products X Net Sales Employee X Employee IC - Net Sales - emp_Firstna - emp_Lastna 1 $140,343.62 Nancy Davolio $108,816.30 Andrew Fuller 3 $165,564.25 Janet Leverling 4 $170,180.32 Margaret Peacock 5 $65,822.35 Steven Buchanan 6 $104,913.32 Michael Suyama 7 $102,515.42 Robert King 8 $140,239.82 Laura Callahan 9 $52,413.10 Anne Dodsworth 4 Customers OrderLines * Order ID Product ID Order_price_per Quantity_ordered Orders Suppliers * Supplier_ID Supplier_Name Contact_Name Contact Title Supplier_Address Supplier_City Supplier_Region Supplier_Zip Supplier_Country Supplier_Phone Supplier_Fax * Order ID Customer ID Employee ID Order Date Required Date Customer_id Cust_First_Name Cust_Last_Name Cust_Birthdate Cust_Income_Bracket Cust_Address Cust_City Cust_Region Cust_zip cust_country Cust_phone Cust_fax Productcosts 7 Product ID Unit Cost Sales Products 10 Sale Lines Product ID Product_Name Supplier_ID Category ID Unit List Price Y Sales Invoice ID 3 Product ID Sales_price_per Quantity_sold Item Discount Y Sales Invoice ID Order ID Customer ID Employee ID Shipped_date Shipper Id Freight_charges Ship to Name Ship to Address Ship to City Ship to Region Ship to Postal Code Ship to Country Units In Stock Units On Order Reorder Level Discontinued Code Employees * Employee_ID emp_Lastname emp_Firstname emp_Title emp_Birth_Date emp_Hire_Date emp_Address emp_City emp_Region emp_Zip emp_Country emp_Phone emp Notes emp ReportsTo Categories g Category_ID Category_Name Category_Description Shippers Shipper ID Shipper Name Shipper Phone File Home Create External Data Database Tools Help Query Design Tell me what you want to do Union Et Insert Rows 3x Delete Rows Builder Insert Columns LJ Delete Columns Return: All B Property Sheet * Table Names View Pass-Through N Data Definition Run Select Make Append Update Crosstab Delete Table Totals Parameters Add Tables Results Query Type Query Setup Show/Hide Chocolate and Coffee Products X Net Sales Employee X All Access Obje... Employees x Sales Salelines Search.. Tables Categories Customers Order ID Customer ID Employee ID Ship Date Shipper Id Freight Charge Employees Sales Invoice ID Product ID Price per Quantity_sold Item Discount Orderlines Orders Product Cost Products Employees Salelines Sales Shippers 1 Employee_ID emp_Lastname emp_Firstname emp_Title emp_Birth_Date I Suppliers Queries Chocolate and Coffee Products Net Sales Employee + Field: Employee ID Table: Sales Total: Group By Sort: Show: Criteria: Net Sales: Salelines]! emp_Firstname Employees Sum Group By emp_Lastname Employees Group By Ship Date Sales Where IS D 0 D n Like *2016* Or Like * or: Employees N Chocolate and Coffee Products X Net Sales Employee X Employee IC - Net Sales - emp_Firstna - emp_Lastna 1 $140,343.62 Nancy Davolio $108,816.30 Andrew Fuller 3 $165,564.25 Janet Leverling 4 $170,180.32 Margaret Peacock 5 $65,822.35 Steven Buchanan 6 $104,913.32 Michael Suyama 7 $102,515.42 Robert King 8 $140,239.82 Laura Callahan 9 $52,413.10 Anne Dodsworth 4 Customers OrderLines * Order ID Product ID Order_price_per Quantity_ordered Orders Suppliers * Supplier_ID Supplier_Name Contact_Name Contact Title Supplier_Address Supplier_City Supplier_Region Supplier_Zip Supplier_Country Supplier_Phone Supplier_Fax * Order ID Customer ID Employee ID Order Date Required Date Customer_id Cust_First_Name Cust_Last_Name Cust_Birthdate Cust_Income_Bracket Cust_Address Cust_City Cust_Region Cust_zip cust_country Cust_phone Cust_fax Productcosts 7 Product ID Unit Cost Sales Products 10 Sale Lines Product ID Product_Name Supplier_ID Category ID Unit List Price Y Sales Invoice ID 3 Product ID Sales_price_per Quantity_sold Item Discount Y Sales Invoice ID Order ID Customer ID Employee ID Shipped_date Shipper Id Freight_charges Ship to Name Ship to Address Ship to City Ship to Region Ship to Postal Code Ship to Country Units In Stock Units On Order Reorder Level Discontinued Code Employees * Employee_ID emp_Lastname emp_Firstname emp_Title emp_Birth_Date emp_Hire_Date emp_Address emp_City emp_Region emp_Zip emp_Country emp_Phone emp Notes emp ReportsTo Categories g Category_ID Category_Name Category_Description Shippers Shipper ID Shipper Name Shipper Phone