Dcount

J

Jean

Is there a way to reset the Dcount based on when a field
changes. For example

Field called;

NAME DCount
A 2
A 2
B 3
B 3
B 3 Thanks!
C 4
C 4
C 4
C 4
 
A

Allen Browne

Use the 3rd argument of DCount() to restrict the count, e.g.:
DCount("*", "MyTable", "[Name] = """ & [Name] & """")
 
Top