DCount-ing from a table - unduplicated

[Guest]

I have a Referral table that is created by a make table query. It lists all
the referrals to outside agencies. The fields are SS#, Name, Referral Date
and Referral Agency. A person can have more than one referral so they would
be listed numerous times in the table. How do I get an unduplicated count of
SS#'s from this table?
I just want to know how many people got referrals; not how many referrals
total.
(I am using DCount boxes from 4 other tables to list on one report)

Thx!

 

[Ken Snell [MVP]]

Create a query (save it as "qryPersons"):

SELECT [SS#] FROM Referral
GROUP BY [SS#];

Then use the qryPersons in your DCount function:

DCount("*", "qryPersons")

 

[Guest]

Excellent - worked the first time! Thank you!
--
Youhooo

Create a query (save it as "qryPersons"):

SELECT [SS#] FROM Referral
GROUP BY [SS#];

Then use the qryPersons in your DCount function:

DCount("*", "qryPersons")

--

Ken Snell
<MS ACCESS MVP>

I have a Referral table that is created by a make table query. It lists
all
the referrals to outside agencies. The fields are SS#, Name, Referral
Date
and Referral Agency. A person can have more than one referral so they
would
be listed numerous times in the table. How do I get an unduplicated count
of
SS#'s from this table?
I just want to know how many people got referrals; not how many referrals
total.
(I am using DCount boxes from 4 other tables to list on one report)

Thx!