help to stop showing duplicate records in a query

[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.

 

[Ken Snell]

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>

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.