Dcount

[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

 

[Allen Browne]

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