Trying to sum values based off of the many records in relationship

[lonesoac0]

Hello all,

I am trying to figure out how to sum up unit values in a one to many relationship. Here is what my data looks like:

Table1:
(PriKey)BuyID FirstName LastName
------------------------------------------
1 Andrrew Anderson
2 Jake Bledso

Table 2:
BuyID FirstName LastName Units
------------------------------------------
1 Andrew Anderson 2
1 Andrew Anderson 1
2 Jake Bledso 2
2 Jake Bledso 3

What I want my query to result in is:
BuyID FirstName LastName Units
------------------------------------------
1 Andrew Anderson 3
2 Jake Bledso 5

How can I perform this kind of query?

[pbaldy]

You want a totals query. Start a regular query selecting those fields. Click on the "E" on the ribbon that says totals query. Change Group By to Sum for the units field.

By the way, the name should not be stored in table 2, just the ID from table 1.