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

Do you want to know the number of DAYS between those two dates, or the number of dates in records in your database that fall between those two dates?


mmcdonal