Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Counting distinct records grouped by date
Unfortunately, Access doesn't recognize both "CAST(variable_name)" and "COUNT(DISTINCT variable_name)". Oh, and I simplified my variable names to "date" and "table" for this post. :) -
Counting distinct records grouped by date
I have a table with 2 fields, "fubar" and "date", in an Access database. "date" stores the dates in the full date format, i.e. date and time, e.g. 2/20/2004 1:34:53PM. "fubar" contains values that may or may not be unique, e.g. the values could be: 12345...
