I am making a query that will total the number of entries made by each shift (A, B, C, D) over a certain period of time.
MY current SQL statement is giving me errors about syntax and/or missing operators.
Code:
SELECT Count(Entries.Shift) AS CountOfShift, Entries.Shift
FROM Entries
GROUP BY Entries.Shift
WHERE ((Entries.EntryDate) = (Between [Enter Start Date] And [Enter End Date]))
ORDER BY Count(Entries.Shift) DESC;
The count works fine, i tested it alone, but I need the date parameter and that is causing the issues.