How can i calculate the number of unique dates within a found set of records?
What is the easiest way to calculate the number of unique dates within a found set of records?
E.g. if the results of my original querie is:
record 1 date: 11/1/2009
record 2 field A: 11/2/2009
record 8 field A: 11/1/2009
record 10 field A: 11/3/2009
(4 records found)
then I also want to know the number of unique dates for the found set (in this case 3, i.e. 11/1/2009 which was found twice only counts as 1)