D
DebRollins
I am trying to count unique records in a formula. For example:
Vendor, Activity Type, Activity Date. I have multiple Activity Types,
but I only want to count the Vendor once. DCount counts the vendor
everytime it occurs.
Vendor 1
Activity C
Vendor 1
Activity D
Vendor 1
Activity E
For the above I want to query for all Activity C and Activity D, but I
only want to count Vendor 1 one time. How do I do this? Dcount gives
me Vendor 1 twice.
Thank you,
Deb
Vendor, Activity Type, Activity Date. I have multiple Activity Types,
but I only want to count the Vendor once. DCount counts the vendor
everytime it occurs.
Vendor 1
Activity C
Vendor 1
Activity D
Vendor 1
Activity E
For the above I want to query for all Activity C and Activity D, but I
only want to count Vendor 1 one time. How do I do this? Dcount gives
me Vendor 1 twice.
Thank you,
Deb