Title makes no sense.
I have a field, TestDate, and I want to count the number of patients whose TestDate is between xx/xx/xxxx and xx/xx/xxxx. I want the query to ask me for those two dates.
This is what I have so far:
SELECT COUNT(TestDate) AS Tested
FROM Patient (My Table)
WHERE TestDate='BETWEEN [Between?] AND [And?]';
When I open the query, it asks TestDate and gives a value of 0 whatever I put in. Could someone tell me what I'm doing wrong, please?
I've never used SQL before, so it would be great if someone knew a good site where I can learn about it.