Count contacts who are associated with campaigns

I have a query which pulls contact IDs from a table and links them to
Campaign IDs from another table. So, a contact ID will show up more
than once if it is linked to more than one campaign.

What I need to do is count how many campaigns each contact is link to
based on the contact ID. How would I do that?

.

Relevant Pages

  • Re: INSTR Statement Access 2000 - PLease help..Under time pressure
    ... Public Function TestSplit(strSearch As String, ... However, in a query, you may also want to use Like as the criteria. ... the Item numbers which make up the campaign. ... the searchstring which is specific to the campaign. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Difficult Query question: TOP 1 + UNION + GROUP BY??!!
    ... you cannot define a query in terms of what it can NOT select. ... You specify criteria that the rows must match. ... top to limit rows by campaign. ... > Indeed there is nothing in the WHERE clause about the campaign-field, ...
    (microsoft.public.sqlserver.server)
  • Re: Table Link from SQL
    ... What I would like to happen is before the form opens, but after I type in the ... value that this new form asks for, for the Campaign table ... use query criteria to make the selection instead of clicking on a form ... "Wayne Morgan" wrote: ...
    (microsoft.public.access.formscoding)
  • Look Up in Query Prompt
    ... developing a query to pull information for one specific ... I added a prompt to the criteria section under ... the campaign field in my query but I would like for the ...
    (microsoft.public.access.queries)
  • Re: MORE THEN ONE QUERIES-- HELP--
    ... > want to group more than one campaign results together. ... > I have 3 queries for each campaign to get the results then the 4th queries ... > This is the first query ... > FROM (tblAccumulativeAgtStats INNER JOIN tblAccumulativeCallResults ON ...
    (microsoft.public.access.queries)