Dcount

  • Thread starter Thread starter Jean
  • Start date Start date
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
 
Use the 3rd argument of DCount() to restrict the count, e.g.:
DCount("*", "MyTable", "[Name] = """ & [Name] & """")
 
Back
Top