I want to show how many orders have been shipped 10 days before the required date in Access SQL, but I can’t seem to get the syntax right.
SELECT COUNT(*) FROM Orders WHERE DATEDIFF(day,RequiredDate,ShippedDate)=10;
Advertisement
Answer
SELECT Count(*) FROM Orders WHERE (((DateDiff("d",[Orders].[RequiredDate],[Orders].[ShippedDate]))=10));