count individual data with duplicates

[MaryE]

I'm new at this and have only a basic knowledge. I'm
trying to help someone figure data from their table, but
some are the same individual, different service. How do
you figure how many Individuals have been served if they
are listed for more than one service?

 

[Drew]

without seeing your table structure, this is a bit of a
shot in the dark, but if the names are the same in
different tables, you can query the tables together and
do a DISTINCT SELECT query or GROUP BY query which will
categories the name if you Group BY the namefield and the
names are JOINED between the tables. DISTINCT will never
allow the query to be UPDATEABLE. USE DISTINCT ONLY WHEN
NECESSARY. Performance issue arise. There are usually
ways around DISTINCT and you can probably use GROUP BY.
Review the table structure and see how "flat"
or "normalized" the tables are. If the names are in
different tables you are not using relational concepts
and therefore have broken one of the BIG 10...
(hehehe) :0)

You may want to post the table structures and let the
wizards on here see the problem and produce and answer

Drew