Beginner Query Help

[Guest]

Is there a way to make subtotals in Access if no primary key is assigned.
For example: Bob and Sharon share a cash register. I have a spreadsheet with
both of there names hundreds of times in column "A". I have the amount they
charged at transaction in column "B". Is there a way to show Bobs name once
and Sharon's name once with a grand total of all the money they have charged?

Any help appreciated.

 

[Jeff Boyce]

Create a "totals" query, grouping by your "columnA" and summing on
"columnB".