Help with count in formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DebRollins@meagape.com - 21 Jan 2008 17:13 GMT

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

Reply to this Message

Pat Hartman - 21 Jan 2008 19:19 GMT

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.

>I am trying to count unique records in a formula. For example:
> Vendor, Activity Type, Activity Date. I have multiple Activity Types,
[quoted text clipped - 16 lines]
> Thank you,
> Deb

Reply to this Message