Re: Summarizing records in one table that match a different table
- From: "TomC" <TomC@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 26 Dec 2005 16:50:02 -0800
OK Tina. I am afraid that my knowledge of doing what you suggested is
lacking. My problem - not yours. I created a new query with the Activities
table. Then in the query design view I added the Clients table and it
automatically linked using the Client ID code. Now I'm looking at the screen
and do not know how to enter the "From Activities Left Join etc."?? So if you
will take me by the hand and lead me through this, as you have done in the
past, I would greatly appreciate it.
Thanks, Tom
"tina" wrote:
> 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:
- References:
- Prev by Date: Re: count mutiple user roles as one
- Next by Date: Re: Report on Total Population changes
- Previous by thread: Re: Summarizing records in one table that match a different table
- Next by thread: Re: Summarizing records in one table that match a different table
- Index(es):
Relevant Pages
|
