asked on

Just curious here, why?

1. I would recommend not creating your table, but the values change.
2. What you want is already available through grouping and summary on a Report.
3. Also, you could get these totals from a query.

Imoutwest

Imoutwest

Sorry, should be:
1. I would recommend not creating your table, BECAUSE the values change.

ASKER CERTIFIED SOLUTION

ldunscombe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ouestque

ASKER

Thanks guys! I got how to make the table, but how do I get the total cost to appear in the second column (As described above) Doing it in query form would be fine if you can do it.

ldunscombe

SELECT Table1.[Book Categories], Sum(Table1.[Book Purchases]) AS [Total Cost] INTO Table2
FROM Table1
GROUP BY Table1.[Book Categories];

Cheers

ouestque

ASKER

Oh yeah sorry idun! you explained that in your earlier post.

Thanks again!!!

Access:Create a Table Sum of Categories