Count # of unique dates

  • Thread starter Thread starter Brian Langley
  • Start date Start date
B

Brian Langley

I have a database table with a column of dates for construction work done.
I need to be able to count the number of unique dates automatically and
display that in a form.

Is there a single function that does this?
 
Use a query containing only the dates. In Query design view click in the
grey area above the white grid, click the Properties button and type Yes
next to Unique Values. In your form you can now have

=DCount("[NameOfDateField]","NameOfYourQuery")
Evi
 
Back
Top