I have this SQL query to find the number of dates in a table between these two dates. Now I want to know how many dates there are. I tried to use count but it didnt work. Any help would be greatly appreciated.

SELECT Cans.FitDate
FROM Cans
WHERE (((Cans.FitDate)>#6/23/2005# And (Cans.FitDate)<#6/30/2005#))
WITH OWNERACCESS OPTION;

JR

If you do it like this it won't work

SELECT Count(Cans.FitDate) as NoRecords FROM Cans
WHERE (((Cans.FitDate)>#6/23/2005# And (Cans.FitDate)<#6/30/2005#))
WITH OWNERACCESS OPTION;


Do this instead . . .

SELECT Count(*) AS NoRecords FROM Cans
WHERE (((Cans.FitDate)>#6/23/2005# And (Cans.FitDate)<#6/30/2005#))
WITH OWNERACCESS OPTION;


And
Tell me one thing what is the meaning of "WITH OWNERACCESS OPTION"??

Thanks for the help. I dont know what WITH OWNERACCESS OPTION; does, it is just what Access puts there when I use the query design mode.