I need to know what is the most efficient way to get the following in vba
count of distinct dates for certain criteria.
for example, how many distinct dates are scheduled for this week.
two schedule records for Sunday are considered 1, while Sun, Mon, Tue are counted as 3.
I know I can do it in a saved distinct query and use DCount of that query, however wonder if that is the most efficient way of accomplishing it, as i am dealing with a very large table.