Help with count in formula

[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

 

[Pat Hartman]

DCount() is a domain function and operates over the entire domain so it has
no way to know that you want to summarize away the details of the
table/query you are using as the source. Create a query that selects Vendor
from the table in question and does a Group by on it (use the sigma button
to make a totals query). Then reference the new query in your DCount()
rather than the original table.