Access Beginner

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

 

[Allen Browne]

1. Create a query into this table.

2. In quey design view, click the Totals button on the toolbar. (Upper sigma
icon.) Access adds a Total row to the grid.

3. Drag the field that contains Bob or Sharon into the grid.
In the Total row, accept Group By under this field.

4. Drag the Amount field into the grid.
In the Total row, choose Sum.