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.
WHERE (((Cans.FitDate)>#6/23/2005# And (Cans.FitDate)<#6/30/2005#))
WITH OWNERACCESS OPTION;