Re: Summarizing records in one table that match a different table
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Mon, 26 Dec 2005 23:14:34 GMT
create a new query with the Activities table, showing all the fields you
need to see about activities. in the query design view, add the Clients
table. link the two tables with a LEFT JOIN from the Activites table to the
Clients table, as
FROM Activities LEFT JOIN Clients ON Activities.ClientID = Clients.ClientID
this will ensure that you get all Activities records, but only those Client
records where there is a matching Activities record.
hth
"TomC" <TomC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AEA3CF2D-36C3-4F77-9275-54CD66E182E0@xxxxxxxxxxxxxxxx
> I have a Clients Table and an Activities Table. There is one entry for
each
> client with identification information. The Activities Table contains an
> entry for each date that something happens to a Client. But not all
Client
> records have an activity and this is what causes my question, because I
don't
> know how to have Access just give me a summary (Count(*)) for the "active"
> clients only. The two tables are linked by a Client ID. I've tried using
a
> Query that ties both tables together as the report source, but it counts
the
> Client record regardless of whether it has a matching Activity record or
not.
> So that is my story, and I'd appreciate any clues you could give me so
that
> it would add only the "matching" Client records.
> Thanks, Tom
>
.
- Follow-Ups:
- Prev by Date: Re: Report on Total Population changes
- Next by Date: Re: count mutiple user roles as one
- Previous by thread: count mutiple user roles as one
- Next by thread: Re: Summarizing records in one table that match a different table
- Index(es):
Relevant Pages
|
