Dcount

[JonyBravo]

Hi there

I'm using DCOUNT to count some fields on some of my tables and I would like to know what can I do to only count repeated fields only once. By example if I've got access in two different fields it only count one.

This is my code:

dcount("[field]", "mytable")

Thanks