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
 
Ad

Advertisements

A

Allen Browne

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top