Count # of unique dates

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?
 
E

Evi

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
 
Top