DCount-ing from a table - unduplicated

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Create a query (save it as "qryPersons"):

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

Then use the qryPersons in your DCount function:

DCount("*", "qryPersons")
 
Excellent - worked the first time! Thank you!
--
Youhooo


Ken Snell said:
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>

Youhooo said:
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!
Click to expand...
Click to expand...
 
Back
Top