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.
x
SELECT COUNT(*)
FROM Orders
WHERE DATEDIFF(day,RequiredDate,ShippedDate)=10;
Advertisement
Answer
SELECT Count(*)
FROM Orders
WHERE (((DateDiff("d",[Orders].[RequiredDate],[Orders].[ShippedDate]))=10));