help to stop showing duplicate records in a query

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

Guest

Simple problem that I cannot seem to solve.

I have 2 tables linked by ID number.

Table 1 has the contact records for individuals. Table two has the individual's contributions to various accounts. Each individual may have many contributions.

I am trying to pull all of the individuals with more than $250 in aggregate contributions. Easy enough.

However, in my query I get a record line for every contribution an indiviudal meeting the criteria has made (some have given 12+ times and therefore show 12+ records.) I would like to be able to run a query that will only show one line for each indidividual meeting the criteria with their total in contributions shown, not a line for each contribution they have made

Any help is appreciated.
 
Try something like this:

SELECT [Table 1].IndividualID, Sum([Table 2].ContributionAmount)
FROM [Table 1] INNER JOIN [Table 2] ON
[Table 1].IndividualID = [Table 2].IndividualID
GROUP BY [Table 1].IndividualID;

--
Ken Snell
<MS ACCESS MVP>

kldietch said:
Simple problem that I cannot seem to solve.

I have 2 tables linked by ID number.

Table 1 has the contact records for individuals. Table two has the
Click to expand...
individual's contributions to various accounts. Each individual may have
many contributions.
I am trying to pull all of the individuals with more than $250 in
Click to expand...
aggregate contributions. Easy enough.
However, in my query I get a record line for every contribution an
Click to expand...
indiviudal meeting the criteria has made (some have given 12+ times and
therefore show 12+ records.) I would like to be able to run a query that
will only show one line for each indidividual meeting the criteria with
their total in contributions shown, not a line for each contribution they
have made.
 
Back
Top