this is the code i am currently working on to output the commission of my car sale but when i run it i get a pop up box with commission asking me to input a value but i just want it to work itself out.
hope someone can help?
SELECT SalesmanNo, CarSaleNo, LicencePlate, Price, SUM (Price) AS CarSaleAmount, SUM (Price * Commission) As CommisionEarned
FROM CarSale
WHERE DateSold BETWEEN #21/11/2015# AND #20/12/2015#
GROUP BY SalesmanNo, CarSaleNo, LicencePlate, Price, DateSold;