Creating a SQL query with three (3) "WHERE" clauses

[gmccray]

SELECT Sum(AppsChecked) AS TotAppsChecked, Sum(AppErrors) AS TotAppErrors, (TotAppErrors)/(TotAppsChecked)*100 AS PctErrors
FROM Stats


WHERE [OperatorId]=[Enter OperatorID] AND [Date]=[Enter Start Date] AND [Date]=[Enter End Date];

The above is the code that I am trying to get to work that will give me the totals apps checked, total app errors with the percentage calculation by a specific user (OperatorId) and over a specific period of time. The operator id and the date range will be inputted by the person running the query. I have gotten the above code to work without the date range. Can someone help. OnLineTestBook.zip
I have attached a zip file with what the data should be in the Access table.

[pbaldy]

The date can't be equal to 2 different dates. I suspect you want:

WHERE [OperatorId]=[Enter OperatorID] AND [Date] Between [Enter Start Date] AND [Enter End Date];

[gmccray]

Thank you so much! I knew it was something with the dates that I was missing, just couldn't see it!

[pbaldy]

Happy to help! If it's not too late, Date is not a good field name; sooner or later Access will confuse it with the Date() function.

Reserved Words in Microsoft Access

[gmccray]

It's not! And Thanks much!